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.
any ideas?