LinkBack URL
About LinkBacks
Here's the SaveAs method text from the help file:
Set NewBook = Workbooks.Add Do fName = Application.GetSaveAsFilename Loop Until fName <> False NewBook.SaveAs Filename:=fName
Here's the SaveAs method text from the help file:
Set NewBook = Workbooks.Add Do fName = Application.GetSaveAsFilename Loop Until fName <> False NewBook.SaveAs Filename:=fName
If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)
You can't do one thing. XLAdept
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin
Please help me understand your code. On "Sheet 2" I want cells B13 & B17 to be used as my file name. Them I want it to save to the same folder as I complete my quotes. Is this possible to do? Where would this code fit into mine? Remember that I am fairly new and still trying to understand writing code. I appreciate your response! Thank you!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks