Using VB.Net Run Code in Excel Module

[Mark]

Not sure if this is the proper forum, but we'll give it a try.

I want my VB.Net program to open an Excel workbook and then execute a VB
procedure residing in the Excel workbook.

I'd like to get sample code to try this out.

Thanks,
Mark

[Cor Ligthert [MVP]]

Mark,

Have a look at these links.

Office
http://support.microsoft.com/default...b;EN-US;311452

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

Pia Download
http://www.microsoft.com/downloads/d...displaylang=en

Excel object model
http://msdn.microsoft.com/library/de...l/ExcelObj.asp

I hope this helps

Cor

[Mark]

Thanks for the references.

"Cor Ligthert [MVP]" wrote:

Mark,

Have a look at these links.

Office
http://support.microsoft.com/default...b;EN-US;311452

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

Pia Download
http://www.microsoft.com/downloads/d...displaylang=en

Excel object model
http://msdn.microsoft.com/library/de...l/ExcelObj.asp

I hope this helps

Cor

[Paul Clement]

On Thu, 28 Jul 2005 05:13:02 -0700, "Mark" <Ma**@discussions.microsoft.com> wrote:

¤ Not sure if this is the proper forum, but we'll give it a try.
¤
¤ I want my VB.Net program to open an Excel workbook and then execute a VB
¤ procedure residing in the Excel workbook.
¤
¤ I'd like to get sample code to try this out.

See the following MS KB article:

How to run Office macros by using Automation from Visual Basic .NET
http://support.microsoft.com/default...b;en-us;306682
Paul
~~~~
Microsoft MVP (Visual Basic)