ireland13752
Member
Hello,
Can you please help me figure out what I need to tweak to get this macro to work again? It worked great until I had to do a Migration from XP to 8.
The code is pretty straightforward, so I am not sure why I cannot see it...
Some quick history: It takes specific tabs within a multi tab file and sets them up to be saved, since each month the name has to change, we have to set it to give the user the option ot change the name and then save them from the Excel version to .pdf, then moved to the next selection and does it again. This is just the saving piece as the rest of it seems to be working okay.
All the steps work except it is not putting the "Name" in the save as box as it did before...
Thank you in advance.
Can you please help me figure out what I need to tweak to get this macro to work again? It worked great until I had to do a Migration from XP to 8.
The code is pretty straightforward, so I am not sure why I cannot see it...
Code:
Sheets("PRMC").Select
Sheets("PRMC").Activate
ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:=Application.GetSaveAsFilename("VBP PRMC 2013-MM.pdf")All the steps work except it is not putting the "Name" in the save as box as it did before...
Thank you in advance.
Last edited by a moderator:
