Password Protecting a TransferSpreadsheet spreadsheet

[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

 

[Ken Snell [MVP]]

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.

 

[Guest]

Cheers Ken,

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

Ta..