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