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!