Simple macro to grab web data

[zhxwn]

Hello

i need a macro that does the following

1. open URL from cell A1 (via Internet explorer)

2. (whilst on webpage) select all and copy

3. Go back to worksheet

4. Paste into cell b2 and ignore source formatting (I want plain text)

i cant provide the URL, or the worksheet I am working on, due to strict company policy . Plus the URL is intranet based.

I can modify any suggestions you provide though and let you know how it goes.

only been working on macros this week, so brand new to it all, just need help getting over this speed bump, I'm building a generator.

Thank you in advance!