I recently completed a VFP app that runs Excel through Automation. This app chops up an input file into pieces, then reassembles these pieces into custom spreadsheets (based on user-specified tables). I'm running VFP 6.0 (SR5) and Excel 97 (SR2) and Windows 2000 (SR2).

This app runs great when the # of output sheets is small (<20). This week I rolled the app out to a larger division in our company. I ran into a Win 2000 memory problem during the Automation session. The error message is:

"The instruction at "0x3013c0e5" referenced memory at "0x079f9fa8". The memory could not be "read"".

The error usually occurs when I am subtotaling a layer of the workbook.
It doesn't occur on the same layer or even the same workbook each time. I've checked the data in the layers and it is OK. In fact I WAS able to get the app to run through the entire group of workbooks once this afternoon - so I know it's not the data. I was only able to do this once. I cold-booted the machine 2 or 3 times, so it's not leaks from earlier attempts.

I spoke with one of our top-tier IT fixit guys and he said this is a known
bug in Win2000 and that they have been seeing it with other MS apps. Could be that our standard image is no good.

Has anyone run into this? Are there issues running VFP/EXCEL in Win2000?

Any insight would be greatly appreciated.