General information
Category:
COM/DCOM and OLE Automation
Title:
Open Excel as readonly
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)
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