View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
NickHK NickHK is offline
external usenet poster
 
Posts: 4,391
Default prompt user to save file as {desired_name} and save it to a variab

Use Application.getsaveAsFilename.

Note that this does not do the .save for you; it just returns a string of
the filepath/name.

NickHK

"GeneWan" wrote in message
...
the code will prompt user to "Save the file as:"

how do I save this user-input string so that I can "open" this file for
writing later on?

thanks!