Solved

Use Dot Net API within VBA

Posted on 2011-09-02
8
447 Views
Last Modified: 2012-05-12
I have an API for Dot Net and I'm hoping there's a way to run it within VBA (MS Access or Excel).

The API controls functionality of another system. It also relies heavily on Event Handlers for events triggered by that other system. I'm hoping there's a way my vba code can actually react to those events.

Doable? Can you guide me to some good reference sources or tutorials? Or, even better, summarize the steps.

Thanks!
0
Comment
Question by:Kaprice
  • 3
  • 2
  • 2
  • +1
8 Comments
 
LVL 40

Accepted Solution

by:
Jacques Bourgeois (James Burger) earned 500 total points
ID: 36472339
Sorry for you, this won't be possible.

It can work in some instances, when the programmer who wrote the API takes into account the fact that it will be called by VBA. They usually don't.

It is hard to connect to simple things in a .NET dll from VBA because the differences between both systems are huge. For instances, dates do not work well because they are not in the same format.

And events are not the same thing at all. They are not declared, nor called, nor handled in in the same way. So subscribing to the events is not possible.

It would be a lot to thing that a Technology that is 20 years old could talk to another one that was developed a dozen of years later. Microsoft could not foresaw .NET when they developed VBA.

0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 36473189
Perhaps you could describe this mysterious "API" for us...?

Perhaps there is something similar in VBA?
0
 

Author Comment

by:Kaprice
ID: 36475264
Perhaps you could describe this mysterious "API" for us...?

Perhaps there is something similar in VBA?

Not likely. It's an interface for controlling another proprietary app.
0
 

Author Comment

by:Kaprice
ID: 36475279
Someone elsewhere suggested the possibility of creating a "wrapper" COM object in Dot Net.  Not sure how practical or challenging that would be, but if anyone has any ideas on how one could do that, I'm open to it.
0
IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

 
LVL 40
ID: 36475465
Wrapper COM objects are created in C++, the only language that permits the use of pointers in the .NET development environment.

If you know somebody who knows C++, how to use it in .NET, as well as the inner workings of COM...

As suggested by Kaprice, there might be something similar in VBA. If the API is a third party API, maybe they had an equivalent version in COM before the arrival of .NET in 2002.
0
 
LVL 75
ID: 36476348
Is there an Object Model for this API / App ?

"As suggested by Kaprice,"
Kaprice is the OP :-)

mx
0
 

Author Comment

by:Kaprice
ID: 36476406
Is there an Object Model for this API / App ?

It doesn't appear so. After installing the API, I looked through the reference list and it wasn't there, so I can't do it the traditional way.


"As suggested by Kaprice,"
Kaprice is the OP :-)

I think he saw me quote the guy who said that and took it as my own. :)
0
 
LVL 75
ID: 36476534
Is there some OCX / DLL or whatever ... such that you can set a reference to it from the VBA References ?  If so, then you can probably see what methods and properties are available.

mx
0

Featured Post

Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Join & Write a Comment

A long time ago (May 2011), I have written an article showing you how to create a DLL using Visual Studio 2005 to be hosted in SQL Server 2005. That was valid at that time and it is still valid if you are still using these versions. You can still re…
This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…

758 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

13 Experts available now in Live!

Get 1:1 Help Now