C application connected to Excel

[Dan Tabla]

Can anyone give me a clue what shall I ask my company programmer in order to
have his C developed software conected with Excel (VBA)?
I m dreaming of not being necesary to ask him to do anything to connect his
application with Excel beside SendKeys ...Any suggestion will be appreciated!

Thanks!!!

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...465cb39&dg=microsoft.public.excel.programming

 

[joel]

I wouldn't use sendkeys where there is a complete set of library (VNe
3.5 & 4.0) functionion available in Visual Studio (2008, and 2010).
recently downloaded the free visual Studio 2008 softwae fro
www.msdn.com and in the tutorials had samples of Excel applications.


below is the microsoft website containing the sample code in C# fo
excel applications. There are similar samples for VB Net and C++.

'Visual C# 2010 Samples - Release: Visual CSharp Samples for Visua
Studio 2010 RTM' (http://tinyurl.com/24legpe)

 

[Dan Tabla]

Dear Joel,
I cant really see how I can use the link that you send me because I dont
know any name of the functions that the C Application is using.

Anyway thank you so much for your answer!

 

[Tim Williams]

Dan,

Maybe you could explain what this C application does, and what "connecting"
with Excel would look like. Do you want to export data to Excel, read it
in from Excel, or what ?

Tim

 

[joel]

I can ask the same question about using the SENDKEY method (dont
know any name of the functions). There aren't SendKey (shortcuts) fo
all the worksheet functions so you probably won't be able to d
everything you need to do.

Microsoft put all the VBA commands into the Visual Studio Libraries (
NET). don't tell you MIS department how to program, just define th
functionality you require. Give them VBA code or Recorded macros tha
meet your requirements.