Export to Passworded Excel spreadsheet

G

Guest

How can I modify a standard Transfer Spreadsheet comand so that it will let
me export an Access query to a password protected Excel Spreadsheet?
 
J

John Nurick

Hi Steve,

You can't modify TransferSpreadsheet to work with a password-protected
Excel workbook. I think the choices are

1) write VBA code that
- opens the workbook, removes the protection, and saves it again
-runs TransferSpreadsheet
-re-applies the protection

(I havent' tried ,but it may be enough just to open the workbook and
run TransferSpreadsheet while it is open).

2) write VBA code that uses the password opens the workbook, inserts the
data without using TransferSpreadsheet, and then saves it.
 

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

Export Data from Queries in Access 2007 to Excel Spreadsheet 1
Export to Pocket Excel 1
Export Query Results to New Spreadsheet 4
Exporting multiple queries into Excel workbook tabs 10
Alt codes 4
Import Updated Data from and Excel to Access 2
Too few parameters exporting to text 14
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0

Top