Save as in a macro

Closed
Report
Posts
2
Registration date
Thursday September 28, 2017
Status
Member
Last seen
September 28, 2017
-
 Blocked Profile -
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 replies


SO, if you go file, save as you cannot place it somewhere else?
0
Posts
2
Registration date
Thursday September 28, 2017
Status
Member
Last seen
September 28, 2017

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
OK, so you are using a print driver?

What print driver are you using? The built in one?
0

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!
0