Previous Topic Next Topic

Save as in a macro

Closed
darrenwilliam007 Posts 2 Registration date Thursday 28 September 2017 Status Member Last seen 28 September 2017 - 28 Sep 2017 à 16:59
 Blocked Profile - 29 Sep 2017 à 17:58
Hi i am trying to save a copy of my workbook ie p&l report plus the date so i can save it each week, so far the macro i have will print all info and clear all data ready for the next week . i got it to save but it will only save as the same filename
Related:

2 responses

Réponse 1 / 2
Blocked Profile
28 Sep 2017 à 17:52
SO, if you go file, save as you cannot place it somewhere else?
darrenwilliam007 Posts 2 Registration date Thursday 28 September 2017 Status Member Last seen 28 September 2017
28 Sep 2017 à 20:37
sorry yes i can then what i would like it to do is save the workbook ie
p&l report 23/9/2017
p&l report 30/9/2017
p&l report 7/10/2017 something like that i have got it to print to pdf and it asks me to input file name clears all content and is ready for next week but i cant get it to ask me for file name even when i use the macro manual it does
darren
Blocked Profile
29 Sep 2017 à 17:55
OK, so you are using a print driver?

What print driver are you using? The built in one?
Réponse 2 / 2
Blocked Profile
29 Sep 2017 à 17:58
YOu can always try to automatically save PDF files without having to rename them. I think there is a an Auto-name feature. Go into options. Document>checkbox for Auto-name Files.


I hope this helps!

Similar discussions

Message cannot be saved as draft (Yahoo attachments)
Cyberpope -
HelpiOS -

1 response
Need For Speed Most Wanted + patch&crack + save editor
karthika -
misharajpoot1995 -

1 response
Ig stories from close friends to public
Darren -
zara -

31 responses
Can't exit Power saving mode
Definer -
adam -

38 responses
cannot save attachment for yahoo email
joesoui -
nisva -

1 response