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.
Now sometimes when I try to run it on Windows 7 64 Bit machine with MS Excel 2010 installed and MS Access 2003 importing a MS Excel 2003 File it hangs if I provide the Path / Filename as a Parameter Field. It works if I replace the Parameter Field hard coded. See attached code or I display the Parameter Field with a MsgBox immediately before the following code line. It's like the Response Time for the Message gives it time to get ready to execute.
Set MSExcelWorkBook = MSExcelApplication.Workboo
, True) 'MS Excel File Path / Filename.
It appears that there is not enough time for the value in the Parameter Field to take effect before the code above is executed.
Could you please take a look at this and advise? .
[Edited by SouthMod]