?
Solved

Exposing a object to VBA macros

Posted on 1998-07-31
1
Medium Priority
?
291 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 30 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

On Demand Webinar: Networking for the Cloud Era

Ready to improve network connectivity? Watch this webinar to learn how SD-WANs and a one-click instant connect tool can boost provisions, deployment, and management of your cloud connection.

Question has a verified solution.

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

There are many ways to remove duplicate entries in an SQL or Access database. Most make you temporarily insert an ID field, make a temp table and copy data back and forth, and/or are slow. Here is an easy way in VB6 using ADO to remove duplicate row…
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…
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
Suggested Courses
Course of the Month14 days, 6 hours left to enroll

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