Controlling Excel

  • Thread starter Thread starter Charley Kyd
  • Start date Start date
C

Charley Kyd

I'd like to learn how to use VS.NET as though it were Excel VBA, with the
goal of creating a compiled Excel addin. That is, I'd like...

....all forms to belong to the Excel environment.
....the ability for my code to run with Excel in design time.
....the ability, if needed, to call VBA routines.
....backward Excel compatibility, to whatever degree is possible.
....etc.

I'm new to VS.NET.

Can anyone point me to information resources that could help me?

Thanks.

Charley Kyd
 
Hi "Charley Kyd"
...all forms to belong to the Excel environment.
...the ability for my code to run with Excel in design time.
...the ability, if needed, to call VBA routines.
...backward Excel compatibility, to whatever degree is possible.
...etc.

I'm new to VS.NET.

Can anyone point me to information resources that could help me?
Click to expand...
I think this is the place to go.

http://msdn.microsoft.com/office/

I saw a lot what you do ask there

Cor
 
Cor,

All I can find on that site, or anywhere, are examples of where VS is the
client and Excel is the server. I want Excel to be the client and VS to be
the server. That's how Excel VBA operates within Excel.

In other words, I'm looking for ways that Excel can call a VS routine that
launches a dialog slaved to Excel, and performs some task. When the dialog
is dismissed, Excel is still in control.

Thanks.

Charley
 
Charley Kyd said:
Cor,

All I can find on that site, or anywhere, are examples of where VS is
the client and Excel is the server. I want Excel to be the client and
VS to be the server. That's how Excel VBA operates within Excel.

In other words, I'm looking for ways that Excel can call a VS routine
that launches a dialog slaved to Excel, and performs some task. When
the dialog is dismissed, Excel is still in control.
Click to expand...

I don't know if it will work they way you need, but you can have a look at
http://msdn.microsoft.com/library/en-us/cpguide/html/cpconexposingnetframeworkcomponentstocom.asp
 
Hi Charley,

Did Armin's suggestion meet your request?
If you have any question on this issue, please post here.

Regards,
Peter Huang
Microsoft Online Partner Support
Get Secure! www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
 
Hi Charley,

Based on my understanding, you want to build an Excel Addin in VS.NET.
And you want to call the Addin method in Excel VBA.
Or you want to automation VS.NET in Excel VBA?
I look forward to hearing from you.

Regards,
Peter Huang
Microsoft Online Partner Support
Get Secure! www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
 
Hi Charley,

If you want to call the Addin method in Excel VBA.
Here is the link may help you.
256624 HOWTO: Use a COM Add-In Function as an Excel Worksheet Function
http://support.microsoft.com/?id=256624

You may also take a look at the link below.

INFO: Develop Microsoft Office Solutions with Visual Studio .NET
http://support.microsoft.com/?id=311452

If you scroll way down until you see the following entry
For additional information about how to provide the groundwork to make a
COM Add-in in Visual Studio .NET, click the article numbers below to view
the articles in the Microsoft Knowledge Base:
KBLink:302896.KB.EN-US: HOW TO: Build an Office COM Add-in by Using Visual
Basic .NET
http://support.microsoft.com/?id=302896


Regards,
Peter Huang
Microsoft Online Partner Support
Get Secure! www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
 
Peter,

I spent half an hour at Barnes & Noble yesterday, looking through .NET
books, trying to find an answer to this question. No luck.

But your links look like they have the information I needed.

Thanks.

Charley
 
Back
Top