Error by write to an Excel Sheet
Q257757 - INFO: Considerations for Server-Side Automation of Office
http://support.microsoft.com/support/kb/articles/Q257/7/57.ASP
Perhaps not a solution, but it does clarify that Office components are nether designed nor intended
for server side use...
"...Microsoft does not recommend or support server-side Automation of Office...."
--
Michael Harris
Microsoft.MVP.Scripting
--
Please do not email questions - post them to the newsgroup instead.
--
Quote:
> Hi!
> - I open, out of an Outlook-Contact a Excelsheet via VBS. After this I copy
> several datafields out of the contact in the sheet and close both.
> - Sometime shit happens :-) and I must recrate the sheet. Therefore I wrote
> an VB-Proggi. This Prog opens several Outlook-Contacts an close it again.
> The VBS in the Contact opens the Excel-sheet an wrote the data using the
> item_close methode. This works with over 1000 contacts, mostly without
> problems... :-(
> - Sometimes it happens that the VBS opens the sheet, but when I write the
> first cell in the sheet with
> objExcelSheet.Range("G1") = Now
> the VBS terminates with 'Object not found'. What could happen between
> opening the sheet and the first access of a cell?
> - After that, I must reboot client because excel is still active in
> Background as an task without window and the server to unlock the xyz.xls
> file.
> When I start it again, it may be fails again after one or two or it runs for
> several hundreds.
> Maybe the sheet needs mor time to open. Anybody knows an 'DoEvents' for VBS
> or any other thing to get more processing time to the execlsheet?
> Idea?
> Thanx
> Chris
