Mike Yearwood
Toronto, Ontario, Canada
Information générale
Catégorie:
COM/DCOM et 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)
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement