Transferspreadsheet password

[Chuck Markson]

I have excel spreadsheets with passwords, Can I somehow
send teh password throught the macro so I can impoer the
files with out changindg every file to not have a password.

Thanks, Chuck

 

[Ken Snell]

No. You'd need to directly manipulate the EXCEL files via Automation (using
VBA code) to open the files with the passwords and then write the data into
the file directly, or to open and resave the files without the passwords,
run the TransferSpreadsheet action, and then open and resave the file with
the password.