MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Input And File Save

Posted by Sam on July 31, 2001 7:55 AM

I need a few line of code that will prompt the user for a file name... save the file as that name... and be able to retain that name for purposes of switching between multiple windows. The only way I know how is to have the user make a file name and then open an inputbox asking for the same thing. I would like to avoid this... any help would be apprieciated.


Posted by Russell on July 31, 2001 9:11 AM

You can do something like this:

Dim strFile As String

strFile = Application.GetSaveAsFilename

ActiveWorkbook.SaveAs strFile

Hope this helps,


Posted by Sam on July 31, 2001 9:20 AM

Thanks, That's What I needed

Thanks again