Password Protecting a TransferSpreadsheet spreadsheet

N

Neily

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
 
K

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.
 
N

Neily

Cheers Ken,

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

Ta..
 
Top