Solved

Exposing a object to VBA macros

Posted on 1998-07-31
1
286 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
1 Comment
 
LVL 2

Accepted Solution

by:
Jagar earned 10 total points
Comment Utility
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

Free Trending Threat Insights Every Day

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

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…
Have you ever wanted to restrict the users input in a textbox to numbers, and while doing that make sure that they can't 'cheat' by pasting in non-numeric text? Of course you can do that with code you write yourself but it's tedious and error-prone …
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…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…

728 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

11 Experts available now in Live!

Get 1:1 Help Now