Calling a .net code webservice from Microsoft Access

  • Thread starter Thread starter John L.
  • Start date Start date
J

John L.

Hi there.

Is there a way to call and use an online web service from Microsoft Office
Access 2003 or 2007?

If so, what are the steps? If you will, please include a code sample of the
call. Thank you for your help.

John L.
 
Sure, why not? From VBA, you can call a web service using any method
available to VB, VBA or VBScript. For a start, see:

http://www.databasejournal.com/features/msaccess/article.php/3567511

http://msdn2.microsoft.com/en-us/library/aa140266(office.10).aspx

http://www.tushar-mehta.com/publish_train/xl_vba_cases/vba_web_pages_services/index.htm

http://www.ddj.com/windows/184416703

You could also use VSTO. With VSTO, you can access any web services just as
easily as with any C# or VB.NET application but you need a knowledge of
..NET.
 
Back
Top