Password Protection

[Gary Cobden]

I need to open and manipulate password protected Excel Spreadsheets
from within MS Access

Is it possible to do this programatically, or will the spreadsheet
always open - like my routine does at present - with the password
prompt?

Thanks

 

[Chip Pearson]

Try something like

XL.Workbooks.Open Filename:="C:\temp\test.xls",
Password:="thePassword"

where XL is your reference to the Excel Application object.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com