Windows Task Scheduler Help

[GoDawgs]

Sorry, I know this doesn't quite fit in this forum, but I wasn't quite sure where to put it. I have an Excel file scheduled to open from the task scheduler...basically I just need to know how to tell it to run a certain macro when it opens from the scheduler. For Access it's just /x "macro name", but that doesn't seem to work for Excel. Any help is much appreciated.

Kevin

 

[dwlerwill]

Have you tried to put the macro on Starup of that Excel Sheet?

Private Sub Workbook_Open()
'Macro Here
End Sub

David Lerwill
"If at first you don't succeed go to the pub"

 

[GoDawgs]

Yeah, that works fine, problem is I don't want it to run every time I open it, just when I open it from the task scheduler...I've kinda worked around it at this point, but I never found a solution to the problem. Thanks though.