Password Protection
 

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

Password Protection
 

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



"Gary Cobden" wrote in message
om...
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