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
Titre:
Excel password syntax
Divers
Thread ID:
00391864
Message ID:
00391864
Vues:
43
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
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform