"sarav_rs" <> wrote in message
news:...
> I am using excel macro to extract the data from web query. To automate
> this, I have created one vb.net windows application to execute the
> macro. And I have created in a schedules task to execute in hourly
> basis. This is working fine in windows 2003 with Excel 2003. After
> upgrading to Windows 2008 Enterprise SP2 with Excel 2010, I have some
> problems.
>
> 1) The scheduled task is started and not fired the excel macro when I
> choose the option 'Run whether the user is logged on or not'
> 2) The user has the Administrator privileges
> 3) The excel macro, VB.Net EXE has the everyone full access
> 4) The user is added in the local security policies (Log on as batch
> job)
>
> But this is working fine, If I change the option as 'Run only the user
> is logged on'. Please help.
Excell has separate security settings on Macros. Check the Macro
Security,...it might be set on high or medium when it needs to be on low.
High keeps it from running at all, medium only runs after acknowledging a
prompt (which won't do you any good),...low should allow the macro the run
without a prompt. Probably when you went from Excell 2003 to 2010 it reset
to the default of High (or Medium?). Also when checking this in Excell it
may be a user specific setting (can't remember for sure) so be sure to log
in and go into Excell with the same acount that the Task runs under.
This was just a guess of course,...so you should also follow Pegasus's post
as well.
--
Phillip Windell
The views expressed, are my own and not those of my employer, or Microsoft,
or anyone else associated with me, including my cats.
-----------------------------------------------------
|
Similar Threads
Linear Mode
