Insert data automatically

[Carleton]

In VBA, what's the easiest way to open a website, say
http://www.usps.com/shipping/trackandconfirm.htm, and have the code
automatically enter the tracking number? If the code can click the
button to submit as well, that'd be great.

Thank you.

 

[MD Websunlimited]

Hi Carleton,

First, you would not use VBA but rather VBScript in ASP or ASP.Net with C# or VB

Next you would not open the page but rather POST the required information to the location specified in the form using MSXML.

Also, I believe the USPS SDK / API has a tracking interface so that the above is not required.

 

[Carleton]

Anyone have a practical answer? If VBA won't allow this sort of
approach then please outline an alternative for use in Microsoft Access.

 

[Thomas A. Rowe]

Suggest you post to the MS Access newsgroup.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
==============================================
If you feel your current issue is a results of installing
a Service Pack or security update, please contact
Microsoft Product Support Services:
http://support.microsoft.com
If the problem can be shown to have been caused by a
security update, then there is usually no charge for the call.
==============================================