I don't believe so. I suppose you could check the time and if it
is within a reasonable margin of your scheduled time, you could
assume it was opened by the scheduler, not a user. This would
work well if you open it up late at night when users wouldn't be
using it. But as far as some property of the workbook itself, I
don't think there is anything to help you out.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Maxwell2006" wrote in message
...
Hi Chip,

Thanks for help.

Is there anyway that my code can distinguish between being open
by user or being open by scheduled task?



Max







"Chip Pearson" wrote in message
...
You can't include in the command line a startup macro name.
You can use the Workbook_Open event procedure in the
ThisWorkbook code module to have code execute when the
workbook is opened.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Maxwell2006" wrote in message
...
Hi,



I have an xls file that contains a VB macro named LOAD_DATA.
The macro loads some data into xls file.



I need to run LOAD_DATA macro every night through scheduled
tasks. Is there any command line to do that?



I there any better way to run a macro inside an excel file
through scheduled tasks?



Thank you,

Max