Export to Passworded Excel spreadsheet

  • Thread starter Thread starter Guest
  • Start date Start date
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?
 
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.
 
Back
Top