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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Export to Excel when password protected 3
TransferSpreadsheet to .xlsx format 4
How to export data from a query to a .xlsx file. 3
Transferspreadsheet import conflict 3
expected format 3
Function or Sub? 9
TransferSpreadsheet 1

Back
Top