Report

Save as in a macro

Ask a question darrenwilliam007 2Posts Thursday September 28, 2017Registration date September 28, 2017 Last seen - Last answered on Sep 29, 2017 at 05:58 PM by ac3mark
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
Helpful
+0
plus moins
SO, if you go file, save as you cannot place it somewhere else?
darrenwilliam007 2Posts Thursday September 28, 2017Registration date September 28, 2017 Last seen - 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
Reply
ac3mark 8017Posts Monday June 3, 2013Registration date ModeratorStatus October 20, 2017 Last seen - 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?
Reply
Leave a comment
Helpful
+0
plus moins
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!
Leave a comment

Member requests are more likely to be responded to.

Members can monitor the statuses of their requests from their account pages.

A CCM membership gives you access to additional options.

Not a member yet?

Sign up now. It takes less than a minute and is completely free!