Use of Visual Basic 2010 and 2010 Express with Excel

[thetexan]

I want to use my Visual Basic 2010 Express to interface and control Excel 2010. Can this be done. I know VBA comes on-board with Excel but it has limited controls. VB1010 and VB2010E both have much more functionality and controls.

So the simple question is...can I use VB2010Express in much the same way as the on-board VBA to create user interfaces with Excel 2010?

Now...if yes...please point me in the right direction for info on the coding necessary to do so.

thank you,

tex

 

[RoryA]

Depends on what you mean by "much the same way"! You can create office add-ins using Visual Studio but you cannot really integrate VB into Excel the same way VBA is.

 

[thetexan]

Depends on what you mean by "much the same way"! You can create office add-ins using Visual Studio but you cannot really integrate VB into Excel the same way VBA is.

First, I would like to have the ability to use any of the VB2010Express controls in their toolbox.

I would like to completely manipulate excel's functionality, such as formulas, charting, etc from the user interface I create with VB2010E. That is the simularity Im refering to.

It may be that VB2010E works as a separate application that calls and used the Excel program behind the scenes. But I can create a much more complex user interface with VB2010E. I just want to know if that is doable or not.

thanks
tex

 

[RoryA]

It is certainly doable.

 

[thetexan]

ADVERTISEMENT

It is certainly doable.

That's great to know. I learn best by studying and experimenting so if you can point me to some resources on interconnectivity between VB2010 and VB2010E and Excel I would greatly appreciate it.

tex

 

[RoryA]

I would have a look at Microsoft's MSDN and its forums.

 

[RoryA]

I would have a look at Microsoft's MSDN and its forums.