Solved

Launching VB.Net code from an Office 2003 Excel Macro

Posted on 2011-03-04
3
312 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
Comment Utility
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
Comment Utility
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
Comment Utility
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

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

The ECB site provides FX rates for major currencies since its inception in 1999 in the form of an XML feed. The files have the following format (reducted for brevity) (CODE) There are three files available HERE (http://www.ecb.europa.eu/stats/exch…
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 this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…
When you create an app prototype with Adobe XD, you can insert system screens -- sharing or Control Center, for example -- with just a few clicks. This video shows you how. You can take the full course on Experts Exchange at http://bit.ly/XDcourse.

771 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

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now