prompt user to save file as {desired_name} and save it to a variab
 

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!

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!