Thread: Use MsgBox to get filename and save .xls file to pre-defined path
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Bill Burlison Bill Burlison is offline
external usenet poster
  
Posts: 2
Default Use MsgBox to get filename and save .xls file to pre-defined path
I would like to use a msgbox and ask a user to input a filename then,
when they hit ok, save the file as "C:\Folder1\Folder2\TheirInput.xls"

I would also like to test for no entry and alert then require entry
again if they don't put information in there.
Reply With QuoteReply With Quote