spreadsheet has a password

[Ed]

The spreadsheet has a password, How can I get this code to work?

DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9, "Bud_XLS",
"c:\bud.xls", True, "etc_db"

ed

 

[Ken Snell [MVP]]

see reply to your same post in another newsgroup.