Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Excel password syntax
Message
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Miscellaneous
Thread ID:
00391864
Message ID:
00391883
Views:
11
Thanks Ken,

You made my brain work. My problem was not enough commas before my password.

Thanks

>Hi Michael,
>
>From VBAXL9.CHM:
>
>expression.Open(FileName, UpdateLinks, ReadOnly, Format, Password, WriteResPassword, IgnoreReadOnlyRecommended, Origin, Delimiter, Editable, Notify, Converter, AddToMRU)
>
>Does oBook = oExcel.WorkBooks.Open(lcFile,,,,'YourPassWordHere') work for you?
>
>What kind of protoction is on the sheet?
>
>>Hi,
>>
>>I've searched all over UT, but am unable to find what I need. I cant figure out the syntax to open a password protected Excel Spreadsheet in VFP. I've never had to open one that has been password protected before. I'm using the standard OLE open and just need to know how to pass the password.
>>
>>My Code is:
>>
>>oExcel= CREATEOBJECT("Excel.Application")
>>lcFile = "c:\myxls.xls"
>>oBook = oExcel.WorkBooks.Open(lcFile)
>>
>>
>>TIA
Michael Helms

May the Schwartz be with you.<(©¿©)> -- Mel Brooks
"Someday, and that day may never come, you will be called upon to perform a service" -- Vito Corleone
"Live like there is no tomorrow, Dance like no one is watching, Love like you've never been hurt." -- Anonymous
"I'm thinking about joining the campaign for shorter tag lines." -- Me
Previous
Reply
Map
View

Click here to load this message in the networking platform