Solved

Launching VB.Net code from an Office 2003 Excel Macro

Posted on 2011-03-04
3
318 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

[Webinar] Code, Load, and Grow

Managing multiple websites, servers, applications, and security on a daily basis? Join us for a webinar on May 25th to learn how to simplify administration and management of virtual hosts for IT admins, create a secure environment, and deploy code more effectively and frequently.

Question has a verified solution.

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

Today I had a very interesting conundrum that had to get solved quickly. Needless to say, it wasn't resolved quickly because when we needed it we were very rushed, but as soon as the conference call was over and I took a step back I saw the correct …
Many times as a report developer I've been asked to display normalized data such as three rows with values Jack, Joe, and Bob as a single comma-separated string such as 'Jack, Joe, Bob', and vice versa.  Here's how to do it. 
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…

752 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