View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
NickHK[_3_] NickHK[_3_] is offline
external usenet poster
 
Posts: 415
Default Macro Save with Worksheet as file Name

Name "OldFileName.pdf" As "Newfilename.pdf"
Add the path as required.

NickHK

"bbkixx" ...
Hello-

I am trying to create a macro that will save a worksheet as a pdf, and
rename the file to the name of the selected worksheet. Now I have the
saving
to pdf part down, but I can't seem to get the renaming of the filename to
the
worksheet part down. Does anyone have some ideas how I can do this?

Any help will be greatly apperciated.

Thank you!
BBkixx