Re: Export to Passworded Excel spread***

Hi Steve,

You can't modify TransferSpread*** 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 TransferSpread***
-re-applies the protection

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

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

On Sat, 10 Feb 2007 16:34:01 -0800, Steve Wood
<SteveWood@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

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

--
John Nurick [Microsoft Access MVP]

Please respond in the newsgroup and not by email.
.