View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
kilo1990
 
Posts: n/a
Default Macro to Prompt for File -- Neophite Needs HELP

Ok, I did replace it, and it actually found the file!! But then the
debug command came up and highlighted the following row:

With Workbooks("Screen Research.xls").Sheet5.Select

Looks like it's confused on where to paste the data. The workbook has
about 15 worksheets in it, and the tab I want to paste the data is
"Last Import" So how do I specify that particular spreadsheet?