I've my code written and working fine for excel data import - however every example I see has the final line set to application.quit() - which is set to close the excel file.
My issue is that it doesn't close the excel application, it instead prompts for a save dialog, even though I have opened the file read only and made no changes to it.
Has anyone else seen this?
Have a look at this article stackoverflow.com/.../closing-excel-application-using-vba
Thanks Anton - yeah actually got round it by using;
The false relating to save changes to the workbook.
Then call application.quit();