Save as in a macro

Closed
darrenwilliam007 Posts 2 Registration date Thursday September 28, 2017 Status Member Last seen September 28, 2017 - Sep 28, 2017 at 04:59 PM
 Blocked Profile - Sep 29, 2017 at 05:58 PM
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

2 responses

Blocked Profile
Sep 28, 2017 at 05:52 PM
SO, if you go file, save as you cannot place it somewhere else?
darrenwilliam007 Posts 2 Registration date Thursday September 28, 2017 Status Member Last seen September 28, 2017
Sep 28, 2017 at 08:37 PM
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
0
Blocked Profile
Sep 29, 2017 at 05:55 PM
OK, so you are using a print driver?

What print driver are you using? The built in one?
0
Blocked Profile
Sep 29, 2017 at 05:58 PM
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!