Jake:

Thanks again for your help.

Matt
-----Original Message-----
Hi Matt,

If you go to the VBE and select Tools | References, look
for Microsoft
Internet Controls and check the box next to it. That
will allow Excel to
use the necessary library for the code to work as written.

Late Binding refers to using the library without
referencing it in your VBA
project. To do this, you would have to declare ie As
Object, use
CreateObject to create an instance of the IE application,
and replace the
READYSTATE_COMPLETE constant with its actual value (4).
If you do all these
things, you don't need to set a reference to the library
to get your code to
work. Late Binding is a lot slower if you're making a
lot of calls to the
library, but in this case, you probably won't notice a
difference. Late
Binding is nice in that you don't have to worry about
whether the user will
have a different version of a library on his/her
machine. And you can trap
the runtime error generated by CreateObject if the
library doesn't exist on
the user's machine. With Early Binding (setting a
reference and declaring
As InternetExplorer), you cannot trap the error the user
will get if he/she
doesn't have the necessary library on the machine.

--
Regards,

Jake Marx
www.longhead.com