transferspreadsheet

[andy_42 via AccessMonster.com]

I am running a simple transferspreadsheet command for multiple excel files.
Each of the files have a password attached and this command won't allow me to
import them without first opening them with the password. I get an error
"Could not decrypt file". Is there a way to feed the password through
transferspreadsheet or should I be going about this differently?

DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9, _
"Tablename", "filename.xls", True


Thanks!

 

[andy_42 via AccessMonster.com]

After more searching I found the following. It appears to work by opening the
excel spreadsheet first, running the transferspreadsheet command, and closing
it.

http://alexdyb.blogspot.com/2005/04/how-to-import-password-protected-excel.html