Macro virus prompt

M

Michael

I want to run a macro daily from a windows Scheduled Task
which works fine, however when the file opens I get the
warning message asking if I want to enable Macro's. I
read somewhere that you can digitally sign the macro and
the message box will not appear, how do I do this.

Thanks in advance
Michael
 
M

Michel Pierron

Hi Michael,
You can use vbscript:
To start by writing with NotePad a small script such as:

' Here, the full path name of the workbook to open
Const xlName = "C:\yyy\xxx.xls"
Dim xl, Wbk
Set xl = WScript.CreateObject("Excel.Application")
Set Wbk = xl.Workbooks.Open(xlName)
' Here, the workbook macro name to execute (in a standard module)
xl.Run "MyMacro"
Wbk.Close True
xl.Quit
Set xl = Nothing

save this file in the same directory "G:\Mike\" with the .vbs extension (for
example: xxx.vbs).

In the task scheduler, put in the "run" box:
"C:\yyy\xxx.vbs"

Regards,
MP
 
J

Jon Peltier

This won't address the original issue, which was the macro warning dialog.

- Jon
 
M

Michel Pierron

Hi Jon,
while thus proceeding, the warning of safety of the macros is by-passed.
MP
 
J

Jon Peltier

Michel -

My apologies, I didn't test it first. Indeed, at least in Excel 2002,
the file with the macro opens without a macro warning, and the macro runs.

I'm rather surprised this works, given the attention that macro viruses
have received over the years.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
 
M

Michel Pierron

Jon,
Yes, you are right, but if that did not function, Excel would not be a true
ole object.
MP
 
Top