Protected Memory Error When Using Automation to Control Excel
Posted on 2007-11-18
I have written a little utility that prints out information in a certain format by using automation to insert the data into an Excel template and then print to the default printer from Excel.
This has all been working fine. I have now upgraded the utility slightly and now, even though I havn't changed the automation part, whenever my app tries to open an Excel file I get an error saying: I have attmepted to read or write protected memory. This then stops my app from working.
Does anyone know why this is happening and what I can do to fix it?