We have MsAccess vba automation to run our night run reports. Query are run, a final table built, a prebuilt Excel workbook (residing on a share) opened, tabs refreshed and saved to SHAREPOINT. The process repeats for numerous reports each night. It ran
flawlessly for years. Since our upgrade to Office 10 this message randomlly appears. If lucky, it quickly dissapears.

However, it tends to pop up and and remain more times than not! You never know which report will be afflicted...its random. I have resorted to babysitting the process many a night...which defeates the purpose of the automation!

When the pop arises, if I hit cancel, my MsAccess vba code errors out...if I hit DEBUG I find it always terminated in the REFRESH EXCEL SHeets function. If I go into task manager I will find a hung Excel session. If I kill the session, return to my codes, drop back a few steps and resume...99% of the time it works fine, refreshing the report and then onto the next query.

Our IS dept is 'logging' my pc but I don't think they have a clue. I suspect the fact that we run WinXP with Office 10 and some dated version of Sharepoint is not helping.

Any ideas?