Who is running Excel workbook?

[SAElmer]

I have a workbook which I run hourly via Windows Scheduler. I also open the workbook manually. I would like to determine which is the "owner", and alter certain "Auto_Open()" actions. I've not discovered the proper function to determine this using VBA (F1) Help.

Can you point me to the function I desire?

TIA, Elmer

[royUK]

Can you explain a little more fully what you man

[SAElmer]

I want to know if a workbook is being run by Windows Schedule or by me (manually).

Is there a function/call to determine this?

[Kenneth Hobson]

The best way to handle that is to pass a command line parameter for one of the methods. If you don't know how to do this, see these examples. The last one is a shorter method than some others.

http://support.microsoft.com/kb/291288

http://office.microsoft.com/en-au/ex...580301033.aspx

http://www.dailydoseofexcel.com/arch...uments-in-vba/

http://www.pcreview.co.uk/forums/thread-2004448.php

http://www.j-walk.com/ss/excel/eee/eee002.txt

http://www.vbforums.com/showthread.php?t=366559

[SAElmer]

The best way to handle that is to pass a command line parameter for one of the methods. If you don't know how to do this, see these examples. The last one is a shorter method than some others.

http://support.microsoft.com/kb/291288

http://office.microsoft.com/en-au/ex...580301033.aspx

http://www.dailydoseofexcel.com/arch...uments-in-vba/

http://www.pcreview.co.uk/forums/thread-2004448.php

http://www.j-walk.com/ss/excel/eee/eee002.txt

http://www.vbforums.com/showthread.php?t=366559

Thank you. I'm going to review these links and adapt to my needs.

[Mordred]

Please don't quote entire posts as they are already there and usually need not repeating. Thanks.