I have C# console application which calls excel, opens excel template and runs number of macros. My macro contains calls of functions from external add-in. the application is supposed to run every night, so I'm using scheduled tasks for this purpose. The problem is that when application runs as scheduled task add-in functions are ignored because excel is running in this case as background proces开发者_StackOverflow中文版s. Has somebody faced with such kind of problem?
Elena
I use excel from windows service, and I use macros as you. And all work fine.
So I suggest to run excel not from standart sheduller. Use external software for it, or implement custom windows service.
精彩评论