EXECL.EXE command line

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" <alanalan@newsgroup.nospam> wrote in message
news:uZEiRvEeGHA.1204@TK2MSFTNGP02.phx.gbl...
> 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
>
>
>
>

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" <chip@cpearson.com> wrote in message
news:%23E0fu7EeGHA.4720@TK2MSFTNGP03.phx.gbl...
> 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" <alanalan@newsgroup.nospam> wrote in message
> news:uZEiRvEeGHA.1204@TK2MSFTNGP02.phx.gbl...
>> 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
>>
>>
>>
>>
>
>

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" <alanalan@newsgroup.nospam> wrote in message
news:OdslgsFeGHA.4128@TK2MSFTNGP05.phx.gbl...
> 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" <chip@cpearson.com> wrote in message
> news:%23E0fu7EeGHA.4720@TK2MSFTNGP03.phx.gbl...
>> 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" <alanalan@newsgroup.nospam> wrote in message
>> news:uZEiRvEeGHA.1204@TK2MSFTNGP02.phx.gbl...
>>> 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
>>>
>>>
>>>
>>>
>>
>>
>
>