One of the EE Experts originally provided this solution which has worked extremely well
on Windows 7 64 Bit machine with MS Excel 2003 and MS Access 2003 installed and
importing from a MS Excel 2003 File.
No when I try to run it on Windows 7 64 Bit machine with MS Excel 2010 and
MS Access 2003 importing a MS Excel 2003 File it fails with the error:
Run-time error '1004 on the following line of code.
Set MSExcelWorkBook = MSExcelApplication.Workboo
, True) 'MS Excel File Path / Filename.
Is this caused by:
- Missing MS Access Reference?
- Need to use MS Excel 2010 File?
- Something else?
Could you please take a look at this and advise? A copy of the code is attached.
[Edited by SouthMod]