View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
dan dan is offline
external usenet poster
 
Posts: 15
Default Import two worksheets into workbook

Hi,

I would like to run a macro which will work like this:

MsgBox "Select file 1"
- Import data dialog box to allow user to select an excel file
MsgBox "Select file 2"
- Import data dialog box to allow user to select an excel file

I dont want to define the path or filename, but want the user to be
able to select the file to import.

Thank you ahead of time for your help!!!!

Dan