Solved

Exposing a object to VBA macros

Posted on 1998-07-31
1
290 Views
Last Modified: 2010-05-03
I generate a data report and control information in 2 separate files. The control information contains information such as number of reports, where the report starts, number of columns etc. The excel VBA macros use that control information and format the data in the excel spreadsheet. Here is what I want to do. As report is generated from the VB, VB program has access to the control information. I want to make an object model from that control information and expose those objects to VBA macros, so that anybody can have easy access to data and do whatever they want with that data.  
How do I expose the objects from VB to excel VBA ? Or any other better suggestions .

I don't have many points, so giving only 10.
 
0
Comment
Question by:sgarg
[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
1 Comment
 
LVL 2

Accepted Solution

by:
Jagar earned 10 total points
ID: 1467399
Create the ActiveX as a DLL this will open the object model to anybody as long as they put a reference to the DLL in there project and you make the objuct MultiUse or Public or something along those lines in the instancing property of the control.
0

Featured Post

Revamp Your Training Process

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action.

Question has a verified solution.

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

Introduction While answering a recent question (http://www.experts-exchange.com/Q_27402310.html) in the VB classic zone, I wrote some VB code in the (Office) VBA environment, rather than fire up my older PC.  I didn't post completely correct code o…
The debugging module of the VB 6 IDE can be accessed by way of the Debug menu item. That menu item can normally be found in the IDE's main menu line as shown in this picture.   There is also a companion Debug Toolbar that looks like the followin…
Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…
This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code. This l…

696 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