If these pages don't use redirects you can use straight HTTP via any
winsock library

OSWinsock is the one (with the sample code)
http://www.ostrosoft.com/oswinsck/oswinsck_vba.asp

SocketWrench is another (there is a number of them on Internet)

hs234


On Thu, 22 Jul 2004 08:19:26 -0700, "Bill"
wrote:

I farm information from several web pages. It's the only method I know of, if there is another one please tell me...

Thanks

"hs234" wrote:

You can only re-distribute msinet.ocx as a part of compiled VB
application, otherwise you almoust certainly will run into licensing
issues

The workaround would be to create a dummy VB app, containing
a form with Microsoft Internet Transfer Control (msinet.ocx) and
generate an installation package for it (with Package and Deployment
Wizard). Don't forget to include your spreadsheet into installation
package.

I wouldn't use msinet.ocx in Excel spreadsheet at all. There are
better alternatives. What do you use it for?

hs234


On Thu, 22 Jul 2004 05:18:01 -0700, "Bill"
wrote:

Yes, I did have VB Pro on the system at one time. One more question - How would I use the workshheet on another system after it's built?

"hs234" wrote:

I believe msinet.ocx could be used only with VB Pro or Enterprise.
You probably had it on your harddrive before the crash.

You can access WinInet API directly, though. Or look for an
alternative. There is plenty of 3rd party components out there.

hs234


On Wed, 21 Jul 2004 06:24:03 -0700, "Bill"
wrote:

I have a macro that access the internet using MSInet. Recently I reformated the harddrive (it crashed). Before the crash I was using the macro without errors. Now when I try to put the msinet.ocx back into the userform I get a message that it's not properly registered, I did registred it with regsvr32.