web crawler won't crawl

[bd3161]

Hi All,
I wrote this crawler 6 months ago and now it gives me error message.

Dim IE as InternetExplorer

"user defined type not defined" error, I use the same exact line in another excel book.
Any ideas?

 

[igold]

You might want to try in the Visual Basic Editor window, go to Tools-->References...--> and check the box for "Microsoft Internet Controls"

 

[bd3161]

Yes, have it checked as well the object library

 

[mole999]

change
Dim IE as InternetExplorer
to
Dim IE

 

[bd3161]

change
Dim IE as InternetExplorer
to
Dim IE

Now I get error message "User defined type not defined"