[AccessD] Calling API's from VBA

[Mark Simms]

Indeed John.....I experienced the same when trying to use a stock trading API.Excel's STA just couldn't hack it...the CPU core would max-out.

Mark Simms
marksimms at verizon.net


-----Original Message-----
From: John Colby <jwcolby at gmail.com>
To: Access Developers discussion and problem solving <accessd at databaseadvisors.com>
Sent: Wed, Sep 9, 2020 5:02 pm
Subject: Re: [AccessD] Calling API's from VBA

The problem is that VBA is single threaded. As long as it only takes a few
seconds you're fine otherwise it appears to be locked up. I ended up using
c# and threads.

On Sun, Aug 9, 2020, 23:05 <newsgrps at dalyn.co.nz> wrote:

> Hi Listers,
>
>
>
> I have a client that wants to be able to call a web api to push data and
> then call another one to pull data back again.
>
>
>
> Does anyone know of resources that can give me guidance as how to do this
> in
> Access?
>
>
>
> Regards
>
>
>
> David Emerson
>
> Dalyn Software Ltd
>
> Wellington, New Zealand
>
>
>
>
>
>
>
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com