c# - Creating a separate Excel process -


i have excel spreadsheet monitors market price of securities.

i market price bloomberg , these values change time long market open.

i have simple vba tool sends me alert every time risk breached.

unfortunately run multiple excel spreadsheets during day , when alert comes other macros stop working.

so i'm thinking if possible write in c# can run excel tool in background totally different process doesn't interfere of other excel workbooks open.

i suggest using microsoft.office.interop.excel implement code in c#.

using above namespace gain full access excel object model, , can monitor different cells.

code read excel file using c# on internet.

the news c# application run in different thread of excel files , not interfere them.

instead of trying write tool run excel tool in background, better approach write tool in c# implement it's logic.


Comments

Popular posts from this blog

How to logout from a login page in asp.net -

Stack level too deep error after upgrade to rails 3.2 and ruby 1.9.3 -