software

Hi
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?
Thanks

I don't know what scheduling program you're using, but maybe you can get around
the problem by having the scheduling program open a helper workbook.

This helper workbook would have a macro named auto_open that would open the real
workbook (by supplying the password) and then get out of the way:

Kind of like:

Option Explicit
Sub auto_open()
Workbooks.Open Filename:=quot;c:\my documents\excel\book2.xlsquot;, _
password:=quot;yourpasswordherequot;
ThisWorkbook.Close savechanges:=False
End Sub

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

--

Dave Peterson

Thanks for the suggestion - from it we'll look at creating a macro that only
saves the password in the output file (after scheduler opens it)- so the
input excell file on the server would not require a password to open. We're
using the Windows Task scheduler.quot;Dave Petersonquot; wrote:

gt; I don't know what scheduling program you're using, but maybe you can get around
gt; the problem by having the scheduling program open a helper workbook.
gt;
gt; This helper workbook would have a macro named auto_open that would open the real
gt; workbook (by supplying the password) and then get out of the way:
gt;
gt; Kind of like:
gt;
gt; Option Explicit
gt; Sub auto_open()
gt; Workbooks.Open Filename:=quot;c:\my documents\excel\book2.xlsquot;, _
gt; password:=quot;yourpasswordherequot;
gt; ThisWorkbook.Close savechanges:=False
gt; End Sub
gt;
gt; VPH wrote:
gt; gt;
gt; gt; Hi
gt; gt; Trying to run a password protected excel workbook in Scheduler - it opens,
gt; gt; updates and is emailed out. ( Jet report).
gt; gt; Scheduler works fine if the workbook is not password protected but hangs if
gt; gt; it is password protected.
gt; gt; Is there anything I can do password protect a document but use scheduler -
gt; gt; possbily a macro that adds the password on saving the workbook?
gt; gt; Thanks
gt;
gt; --
gt;
gt; Dave Peterson
gt;