using VB with excel

[renoald]

i am using Visual Basic 2005 express edition. I want to build a program that can be run to Excel.
The condition like this:
i)i have a set of value , when i click the button, excel will plot the graph by using the value.

ii) i want to read the value from table in excel by using Visual basic , open the excel file and then read the value
can vb2005 done with this?
Please give me idea!

[Xav]

You need to find out how to automate Excel. You add a reference to the COM library and then call upon the namespace, creating an ExcelApplication class and determining the methods to use from there, either the documentation or the IntelliSense.

[marwex89]

Um, sounds like you could look at VBA (Visual Basic for Applications)? Excel, Word etc already has inbuilt support for VB..

[Xav]

He can still do it in VB2005 if he wishes, with API automation.

[marwex89]

He could, but it sounds like it's not what he really wants
Up to him

[Xav]

i am using Visual Basic 2005 express edition. I want to build a program that can be run to Excel.

He clearly wants to use VB2005 and then access Excel. Therefore, VBA is out of the question.

[marwex89]

To me it sounded more like he wasn't aware of VBA and it's potential... If I was wrong, hell let him go mad with Automation/ActiveX or whatever approach he chooses

[Xav]

He could use VBA if he wanted to, and write some macros, but there are security limitations involved, and he DEFINITELY wants to do it in a separate program, not just having to call macro functions.

[marwex89]

I don't know what he wants...? He tell us..

[Xav]

He did tell us. He told us he wants to use VB2005, VB.NET. He doesn't want to have to open the Excel document just to run the code. Otherwise, the code is pointless, he might as well just do it manually. Therefore, he wants to use VB2005.