Scheduler and passwords

Giganews Newsgroups
Subject: Scheduler and passwords
Posted by:  VPH
Date: Thu, 18 May 2006

Trying to run a password protected excel workbook in Scheduler - it opens,
updates and is emailed out.  ( Jet report).
Scheduler works fine if the workbook is not password protected but hangs if
it is password protected.
Is there anything I can do password protect a document but use scheduler -
possbily a  macro  that adds the password on saving the workbook?