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
Title:
Excel password syntax
Miscellaneous
Thread ID:
00391864
Message ID:
00391864
Views:
44
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
Next
Reply
Map
View

Click here to load this message in the networking platform