Y
youxing
I design an OLE server, and in the excel spreadsheet, I have macro that
create OLE object and and OLE object will updatie the data in spreadsheet.
it works fine under Excel 97/2000 for long time, but now under Excel
2002/2003, sometimes I got "OLE error 800AC472".
the problem happens when it took OLE server too long to update the data in
spreadsheet, if it take less than one minute to update spreatsheet,
everything is fine, but when it takes more than 2 minutes, it raises
exception. it looks like EXCEL disconnects from the OLE server. but again,
it works fine under Excel 2000.
please help.
Simon
create OLE object and and OLE object will updatie the data in spreadsheet.
it works fine under Excel 97/2000 for long time, but now under Excel
2002/2003, sometimes I got "OLE error 800AC472".
the problem happens when it took OLE server too long to update the data in
spreadsheet, if it take less than one minute to update spreatsheet,
everything is fine, but when it takes more than 2 minutes, it raises
exception. it looks like EXCEL disconnects from the OLE server. but again,
it works fine under Excel 2000.
please help.
Simon