开发者

how to call excel macro which contains call of external add-in from C# application?

开发者 https://www.devze.com 2023-02-11 00:38 出处:网络
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 nig

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.

0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号