Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Excel password syntax
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
COM/DCOM et OLE Automation
Divers
Thread ID:
00391864
Message ID:
00391883
Vues:
12
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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform