C
Col Werner
Guest
Hi,
I've written a simple macro to send an excel sheet to save as a PDF. I've got a specific (changable) name that I'd like it to save as but I can't quite work out what command to give it so that it pastes the name (which I've copied in excel in the macro - called "Filename_Paste") as the new file name.
For example my PDF saves onto my desktop as Filename_Paste.PDF whereas I'd like to save as "Simon and Betty Anderson 3-6-2020" which is what I've just copied in the macro using Filename_Paste as a named range.
Any clues would be appreciated!
Col
Continue reading...
I've written a simple macro to send an excel sheet to save as a PDF. I've got a specific (changable) name that I'd like it to save as but I can't quite work out what command to give it so that it pastes the name (which I've copied in excel in the macro - called "Filename_Paste") as the new file name.
For example my PDF saves onto my desktop as Filename_Paste.PDF whereas I'd like to save as "Simon and Betty Anderson 3-6-2020" which is what I've just copied in the macro using Filename_Paste as a named range.
Any clues would be appreciated!
Col
Continue reading...