Web parsing with Inet Control and Regex

[stanl]

I was just playing around as I may do some extensive parsing of Census data. The attached workbook contains a vba module that will parse out World Population projections. Just illustrates a different way to get data and is quite fast.

Just thought I'd throw it out for anyone to play with. Stan

[JP2112]

When I run the code I get an error on this line:

Set oInet = CreateObject("InetCtls.Inet.1")

"ActiveX component can't create object"

Any idea what library that belongs to?

Thx

[stanl]

When I run the code I get an error on this line:

Set oInet = CreateObject("InetCtls.Inet.1")

"ActiveX component can't create object"

Any idea what library that belongs to?

Thx

you just need msinet.ocx registered. It is a free download and comes with the "tweak" (tweakXP etc..) packages.

[tepkool01]

Ah this is great! Thanks!

[stanl]

Ah this is great! Thanks!

You are most welcome. :friends: