Export to Excel With Password

[Ross]

I would like to export an Access query into a new Excel spreadsheet and have
the spreadsheet be created with password protection (automatically). Is it
possible.

I am award that I could export to and existing template, etc, but this is my
Plan B.

Thanks you

Ross

 

[John Nurick]

Hi Ross,

You'd have to write Access VBA code that launches Excel, opens the
workbook, aplies the password protection and saves it. Here are a couple
of articles that may help you get started:

Sample Excel automation
http://www.mvps.org/access/modules/mdl0006.htm
ACC2000: Using Automation to Create and Manipulate an Excel Workbook
(Q210148) http://support.microsoft.com/?id=210148

 

[Ross]

Thanks John!

Hi Ross,

You'd have to write Access VBA code that launches Excel, opens the
workbook, aplies the password protection and saves it. Here are a couple
of articles that may help you get started:

Sample Excel automation
http://www.mvps.org/access/modules/mdl0006.htm
ACC2000: Using Automation to Create and Manipulate an Excel Workbook
(Q210148) http://support.microsoft.com/?id=210148