Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Does Foxpro know if an Excel workbook is being modified?
Message
 
 
To
20/11/2000 09:50:08
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00443610
Message ID:
00443959
Views:
8
David,

From the Vbaxl8.hlp file expression.Open(FileName, UpdateLinks, ReadOnly, Format, Password, WriteResPassword, IgnoreReadOnlyRecommended, Origin, Delimiter, Editable, Notify, Converter, AddToMRU)

This works for me:

olewbook.open("C:\My Documents\umr address.xls", , , , , , .t. )

>I've used the following code to open up an excel workbook.
>
>oleapp = createobject('excel.application')
>oleapp.visible = .t.
>olewbook = oleapp.workbooks
>olewbook.open('p:\test.xls')
>
>If the workbook is already opened up by someone else prior to running the above code and error is generated when the line "olewbook.open('p:\test.xls')" is executed. Foxpro can't open up the file for read/write because someone else has it opened. How can I test if the excel workbook is opened by someone else before running this code?
df (was a 10 time MVP)

df FoxPro website
FoxPro Wiki site online, editable knowledgebase
Previous
Reply
Map
View

Click here to load this message in the networking platform