search

VBA-tools / VBA-Web

VBA-Web: Connect VBA, Excel, Access, and Office for Windows and Mac to web services and the web
http://vba-tools.github.io/VBA-Web/
MIT License
2k stars 494 forks source link

Access 2003 Compatible? #343

Open dbarou55e opened 6 years ago

dbarou55e commented 6 years ago

Is this compatible with Access 2003? I get a compile errors once installing the WebRequest and WebClient classes. Any advice?

dbarou55e commented 6 years ago

compile-error2

Sophist-UK commented 6 years ago

You may have to add libraries in Tools / References... to avoid these errors.

dbarou55e commented 6 years ago

Thank you for your reply. There is nothing in the documentation about adding additional references. Any suggestions which libraries would be required? There are quite a bit of them available.

Sophist-UK commented 6 years ago

You will need to research - and please feedback so that documentation can be updated.

janeinari commented 6 years ago

Seams you are missing a module. WebMethod is defined in WebHelpers.Bas file. So guess you have forgot to import this. But you should also make a reference to the Microsoft Scripting Runtime, and Microsoft WinHTTP Services. I am using this class library i MSAccess 2010, 2013 and 2017 successfully for several years. Only thing you have to disable / remove manually is the Application.OnTime line in class WebAsyncWrapper sub web_StartTimeoutTimer (as this is not supported in Access), meaning you want be able to execute Async requests..

dbarou55e commented 6 years ago

Thank you! This was the answer -> Microsoft WinHTTP Services

Did I miss that in the documentation?? At any rate, it compiles now. Thank you so much!!