I want to copy some text from IE and paste it into a worksheet, when I
use the macro recorder it doesn't give me the proper code. If anyone
can get me pointed in the right direction I would greatly appreciate
it. Thanks

Hi

The best option would to use Internet Explorer Object and get the text using
InnerText or InnerHTML property

The following links can give you some info

http://msdn.microsoft.com/en-us/library/aa752084(VS.85).aspx
http://vbadud.blogspot.com/2008/05/g...using-vba.html

Cheers


http://vbadud.blogspot.com


"(E-Mail Removed)" wrote:

> I want to copy some text from IE and paste it into a worksheet, when I
> use the macro recorder it doesn't give me the proper code. If anyone
> can get me pointed in the right direction I would greatly appreciate
> it. Thanks
>

Thanks for the input. I will give it a look and see if I can get
anywhere from it.