Solved

Launching VB.Net code from an Office 2003 Excel Macro

Posted on 2011-03-04
3
316 Views
Last Modified: 2013-12-17
Here's a good one. I need to launch a .NET assembly from the VBA Macro in an Excel 2003 Workbook. I need to do this to take advantage of the additional abilities of the .NET framework when dealing with XML.
0
Comment
Question by:jinksk1957
3 Comments
 
LVL 10

Expert Comment

by:ALaRiva
ID: 35039359
Are you trying to get returns from the .Net Code and use it's functions/methods?

Or do you want it to run it unattended?
0
 
LVL 11

Accepted Solution

by:
lenordiste earned 500 total points
ID: 35043904
i found that post a while ago, it might be of some use to you especially if you are building your own .NET assembly:
http://richnewman.wordpress.com/2007/04/15/a-beginner%E2%80%99s-guide-to-calling-a-net-library-from-excel/
0
 

Author Closing Comment

by:jinksk1957
ID: 35057983
Solution was to go to a link with no commentary on whether the "lenordiste" had actually gotten the example to work. That is the only reason for the "partially" grade on "completeness"
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Error message when using PrintSocket.Send 7 18
Syntax Issue with SSIS module 26 104
Powershell import xml to array (non-cli xml) 4 18
VB.NET Textbox input validation 4 40
Exception Handling is in the core of any application that is able to dignify its name. In this article, I'll guide you through the process of writing a DRY (Don't Repeat Yourself) Exception Handling mechanism, using Aspect Oriented Programming.
Calculating holidays and working days is a function that is often needed yet it is not one found within the Framework. This article presents one approach to building a working-day calculator for use in .NET.
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

860 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question