Saving a file as a specific name using VB

  • Thread starter Thread starter Col Werner
  • Start date Start date
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...
 
Back
Top