Mike Yearwood
Toronto, Ontario, Canada
General information
Category:
COM/DCOM and OLE Automation
Hey Bob
Check the Windows task manager for occurances of Excel. At each VFP crash, there will be another instance of Excel. Close them all and when your program loads the spreadsheet again, everything will be fine.
>My first attempts at reading Excel from VFP. While I'm debugging, sometimes when the program crashes, it leaves the Excel worksheet in a readonly state. That's fine for the VFP program, since I'm only reading it. But it means I can't go to Excel and change my test data. Once its readonly, I have to reboot to clear the problem.
>
>It seems I should open the worksheet as ReadOnly but I don;t have info on how to do this.
>
>I have
>
>oExcel=CreateObject("Excel.Application")
>oWorkbook = oExcel.Workbooks.Open(thisform.xlsname)
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only