Internet Content

[keith]

I have a word doc that connects to a sqlserver to get a number that is
printed in the header of the document, and increments the number so the next
printing is the new number. This is to be distributed to multiple users.

However, I cannot get through the users firewall and getting them to open
ports is out of the question. However I can get though port 80.

I can create an asp page that displays this number and takes a querystring
value to increment the number.

I am looking for ways to connect to my asp page. If this was VB it's be easy
to do, but I'm trying to do this in VBA using things that my users would
typically have - Word2003 and IE, running on XP.

Suggestions on how to get internet content using VBA would be appreciated. I
tried the CreateObject("InetCtls.Inet.1") method but had a "Active X Cannot
Create Object" error.

Keith

 

[Jezebel]

Create a UserForm and add an Inet control to it.