Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How i to call up, EXCEL..... protect file
Message
From
21/05/2001 07:43:05
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Other
Title:
How i to call up, EXCEL..... protect file
Miscellaneous
Thread ID:
00509390
Message ID:
00509390
Views:
52
Hi, i use CREATEOBJECT to modity a EXCEL.
how can i call up the PROTECT function in worksheet (file), that can
not allow any user to modity my file (output).

That is my part of program about call up the EXCEL file.

*****
OEXCEL = CREATEOBJECT("EXCEL.APPLICATION")
OEXCEL.SHEETSINNEWWORKBOOK = 1
OWORKBOOK = OEXCEL.WORKBOOKS.OPEN(MYFILE)
OACTIVESHEET = OEXCEL.ACTIVESHEET
OEXCELAPP = OEXCEL.APPLICATION
WITH OEXCEL
.CELLS(7,5).VALUE= "Document no : 12345"
ENDWITH
OWORKBOOK.SAVE()
OWORKBOOK.CLOSE()
OEXCEL.QUIT()
*****
Next
Reply
Map
View

Click here to load this message in the networking platform