Win XP64 bit vs Win 7 64 bit both Office 2007

[racer25]

Hi

I have a work PC with XP 64 bit and a laptop with Win 7 64 bit both running Office 2007.

The below code works perfectly on the Win 7 machine, however on the XP machine while the code runs to completion most of the time sometimes it fails with varying error messages.

I found the reason for the failures to be part way through the code is an Excel routine, which ask Excel to Save, Close then Quit. On the XP machine when I open task manager, I have dozens on Excel instances open. Further if I run the code with task manager open and kill them one by one the code always run through to the end.

I have tried adding taskkill into the code but due to the speed of the process it kills both the running task and the new one that is starting.

Am I missing any patches/add-ins (anything) that will avoid upgrade to Win 7. Is their a smarter way of resolving this?

Thanks in advance

Rob

Please Login or Register  to view this content.

[romperstomper]

Do you have a reference set to Excel? I would guess not since you are using CreateObject (though you might). If you don't then you can't use Excel constants - they will all just have a value of 0.
I don't think that's actually your issue though - you might try using:

Please Login or Register  to view this content.

[racer25]

Hey romperstomper,

I do have a reference set to Excel - just tried your code unfortunately no change still numerous instances of Excel.

Thanks for taking a look and if you have any more thoughts they are appreciated.

Rob

[romperstomper]

Try making the app visible in your code and see if there are any dialogs left open as you step through and try to quit.

[racer25]

To the ***** eye its closing the app.

No dialogues, file opens changes are made file saves, file closes and Excel closes... Excel opens and loops again through changes,save then close and quit. - Task Manager though says different.....

Rather infuriating.

I had it running on the laptop sat next to it - exactly same except Task Manager was not filling with Excel instances.

[romperstomper]

Are you watching the Task manager to see at what point the excel instance is created?
Incidentally, it would be a lot more efficient to start Excel once outside your loop, process all the files you need to inside the loop, then close Excel at the end.

[racer25]

Taking out the quit part does not work either - which I assume is what you were aiming at for the efficiency as when we get back to

Please Login or Register  to view this content.

it opens up another version anyway.

Maybe I am over simplifying this but if the same code works perfectly on another machine albeit different operating system and further to complete the loop I have now tested this on a 32 bit version of XP and again works fine.

• Win 7 64 bit Perfect
• XP 32 bit Perfect
• XP 64 bit problems as outlined.

I spent some time googling and could not find anything other than using a TASKKILL command and then pausing for 20 seconds until clear given on a bad month we would have 400 files which adds hours on to the process.

Thanks for looking

[romperstomper]

No, I was suggesting moving the CreateObject part too - more like this:

Please Login or Register  to view this content.

[racer25]

Still creating multiples .... copy and paste

I gave in about half an hour and IT are going to put Win 7 on my PC as a last resort.

XP 64 bit is not the most use friendly with all its driver issues so hopefully kill two birds with one stone. That said if a few lines of code or reinstall would have fixed it great.

Thanks for your time