Transferspreadsheet password

  • Thread starter Thread starter Chuck Markson
  • Start date Start date
C

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
 
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.
 
Back
Top