Use WEB Services API in MS Access / VBA

Posted on 2011-05-11
Last Modified: 2012-05-11
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
Question by:Louis Capece
    LVL 68

    Expert Comment

    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:

    LVL 31

    Expert Comment

    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?
    LVL 68

    Accepted Solution

    Sorry for my comment above - wrong thread!

    Sorry again!


    Author Closing Comment

    by:Louis Capece
    Not really an applicable solution

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Threat Intelligence Starter Resources

    Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

    zlib is a free compression library (a DLL) on which the popular gzip utility is built.  In this article, we'll see how to use the zlib functions to compress and decompress data in memory; that is, without needing to use a temporary file.  We'll be c…
    The purpose of this article is to demonstrate how we can upgrade Python from version 2.7.6 to Python 2.7.10 on the Linux Mint operating system. I am using an Oracle Virtual Box where I have installed Linux Mint operating system version 17.2. Once yo…
    This is Part 3 in a 3-part series on Experts Exchange to discuss error handling in VBA code written for Excel. Part 1 of this series discussed basic error handling code using VBA.…
    Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

    761 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

    9 Experts available now in Live!

    Get 1:1 Help Now