If I run a query in excel through VB using the excel object library, it works fine the very first time I do it in my application. Subsequent runs I get the following error:
Error 1004 Method 'Range' of object '_Global' failed.
I am closing down the work book and application objects properly between the attempts. If I close down my app, and retry it works every time !
Any ideas please ???