Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Open Excel as readonly
Message
From
01/02/2004 13:34:21
Mike Yearwood
Toronto, Ontario, Canada
 
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Miscellaneous
Thread ID:
00872785
Message ID:
00872786
Views:
17
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
Map
View

Click here to load this message in the networking platform