A
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!
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!