Save As in VBA
 

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!

Save As in VBA
 

You might be able to modify the "Save Changes?" example on my web site.

--
Rob van Gelder - http://www.vangelder.co.nz/excel


"Bill D." wrote in message
...

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!

Save As in VBA
 

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!

Save As in VBA
 

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

--
Message posted from http://www.ExcelForum.com

Save As in VBA
 

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

--
Regards,
Tom Ogilvy

"Ripan " wrote in message
...
I have used the same approach to saving. However, the file actually does
save, just not with the name I specified. I noticed the name I pass
into the GetSaveAsFileName method appears in quotes, I do not know if
this is something I need to change.

Any ideas?


---
Message posted from http://www.ExcelForum.com/