• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1448
  • Last Modified:

Use WEB Services API in MS Access / VBA

I have a MS Access 2003 application in which I am trying to see about implementing a web API call. I have attached the actual PHP code of the API, so I am hoping to be able to create a VBA function in which I pass a text string, the API goes out to the provider, the text get altered , API passes back to windows/ VBA for reading.

I beleive Microsoft has a web services object addon that Access can reference. Any guidiance is appreciated. api.txt
Louis Capece
Louis Capece
  • 2
1 Solution
I think STM (xstm, mstm, csmt) is the tool of choice here.

You'll need to have the Support Tools Manager installed.


echo 'selclass qualifier memory;wait;info;Infolog' | cstm

Here is a thread on that topic:

Well, I have been doing something very similar to what you are describing except that I was using Excel.  Here is how it worked.

First, I had to make CGI calls. Lets me try to explain what am I talking about.

Suppose I opened internet explorer and pasted by CGI call in the address bar like


So I passed these values to the CGI program.  In return I received some XML or text values in the body of IE.

This is exactly what I did in Excel. I created a form and put a web browser object.  My calls sent values to IE and read values from the body of IE.  I hid IE in the body of form.

Making sense?
Sorry for my comment above - wrong thread!

Sorry again!

Louis CapeceAuthor Commented:
Not really an applicable solution

Featured Post

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now