Password Protecting a TransferSpreadsheet spreadsheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I'm using the DoCmd.TransferSpreadsheet acExport to export a table as an
Excel spreadsheet.

Does anyone know of a way I can add a file protection password to this
exported spreadsheet, so that it can only be opened with the password.

Thanks

Neil
 
Not as part of the TransferSpreadsheet action itself. You'd need to use
Automation to open the EXCEL file after it's created and to then add a
password to it (you may want to ask in the EXCEL newsgroups how to add a
password programmatically), then save it and close the file.
 
Cheers Ken,

I came to that conclusion after reading a few other related posts, so I'm
reading up on that one.

Ta..
 
Back
Top