I have this save as macro that I'm using to save from a certain cell, it works fine but it saves to the last place I saved a previous file how can I have it open up the browse window to choose where I want to save it?
Here is the macro I'm using
Please Login or Register to view this content.
Last edited by mrggutz; 08-09-2010 at 11:54 AM.
Open up the VBEditor and put this macro into the ThisWorkBook module, it completely replaces the SAVE function. If it's a SAVEAS, it will offer a name based on the cells desired:
Please Login or Register to view this content.
Be sure to edit the sheet name in the macro to the correct one.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Thanks for that it works good, but how do i get it to just give me the file name without the extension...example I picked a 1234.jpg in my excel template and when I saved it, it was a .jpg file and not a .xls file. Please advise and thx for the help.
mrggutz
Try this:
Please Login or Register to view this content.
If that takes care of your need, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.
I'll give it a try thx.
Re: SaveAs macro
That worked great thx abunch.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks