From Friday, April 19th (11:00 PM CDT) through Saturday, April 20th (2:00 PM CDT), 2024, ni.com will undergo system upgrades that may result in temporary service interruption.
We appreciate your patience as we improve our online experience.
i created an application that allows the user to read in an excel spreadsheet, chop it up, then stuff it into a database. it also can generate 2 reports as excel spreadsheets . when i run the reports alone it works fine but when i chop up the spreadsheet it tnds to screw up excel. it does not cause any faults but it does cause excel to open like this: all you see is the frame of excel you don't see the contents of the doument, in fact you see right through the window to the background. in the spreadsheet chop i use all active X calls to open the document in the background, read it then close the document.. for the reports i create the documents by writing the file with "write to speadsheet file" then opening the doc within excel.
My only idea is to make sure that all ActiveX references are closed to Excel (every ActiveX wire should end in a Automation Close function). Other than that, it may be an issue with the ActiveX object for Excel. Contacting Microsoft may be a possibility.
Randy Hoskin Applications Engineer National Instruments http://www.ni.com/ask
