View Single Post
  #5   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

Thanks you two. I have learned a bunch about msgbox in trying to do
this. Guess I can start on input boxes now. Your help will make the
start easier! Much asppreciated.

On Wed, 08 Nov 2006 11:58:05 -0800, Bill Burlison
wrote:

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.