Transfering data into excel automatically..if excel active


Is there way for data aquistion routine to detect if excel is actaully running, if this is active, however to transfer data array into excel automatically?.

If the excel is not running, it performs a scan for existance then it popup window asking operator if he wish to excutes the excel and then transfer data. Operator simply click Yes button and then it load the excel and provide feedback that excel is ready and hence transfer data.

I perfer to restrict coding to this program (master) rather than excel.

Program example would be exteremely useful.

Thanks

 

riscyAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

TheAvengerCommented:
Here a link to a short tutorial about Excel programming with C#:
http://www.c-sharpcorner.com/Code/2003/May/Excel2003fromCSharp.asp

Some helpful links for starting your work:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnoxpta/html/odc_oxppias.asp
http://www.microsoft.com/downloads/details.aspx?FamilyId=C41BD61E-3060-4F71-A6B4-01FEBA508E52&displaylang=en

This is a refence to the Excel programming objects for VBA, which are exactly the same as the object in .Net:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vbagr11/html/grobjRange1.asp

Unfortunately I could not find any information on how to check if Excel is running :-((
TheAvengerCommented:
Here is a link to check if Excel is running in Delphi. I suppose you can make almost the same in C#:
http://www.swissdelphicenter.ch/torry/printcode.php?id=294

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
C#

From novice to tech pro — start learning today.