Save As in VBA

B

Bill D.

I want to put a Save AS button on a worksheet that will open the Windows
SaveAs dialog box so the user can select the path to where he wants the
worksheet saved. An inputbox will ask for the new file name prior to
opening the SaveAs dialog box.

Bill

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
 
B

Bill D.

Thanks Rob for the help and another great resource to add to my list.
I have been using the GetSaveAsFilename but so far the file is never
actually saved. I know I'm doing something wrong but your reply at least
tells me I am using hte correct command.

Thanks

Bill


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
 
R

Ripan

I have used the same approach to saving. However, the file actually doe
save, just not with the name I specified. I noticed the name I pas
into the GetSaveAsFileName method appears in quotes, I do not know i
this is something I need to change.

Any ideas
 
T

Tom Ogilvy

It something you are using now doesn't work or doesn't work as expected,
then change is definitely an option.
 
Top