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?
|