Hello,

After one week of struggling to get my problem solved i've decided to get help from people who are more experienced than i am.

First, im using Excel 2007, Win7 32bit.

Something to get you familiar with situation:

I'm trying to get content of the web page to Excel Worksheet. I got VBA macro which opens IE, using link i need to get data from. Until this stage i have no problem.

This is how web page looks when fully loaded. (Can't provide link since page runs at Intranet)
http://img855.imageshack.us/img855/1661/reporttb.jpg

Notice that there is Control panel at the top of page and the real infomation is generated by Javascript which under this Control Panel, begins with "Throughput" header (Just lets call this area Real Information Area ). Page acts like Control panel and the information area below panel are separated "pages / elements"

Root issue:
Please Login or Register  to view this content.
When page is loaded i'm using command for selecting all(then copying) page content. Command it self works but it selects entire page even with the Control panel and when i want to paste copied data into excel it pastes only control panel elements and the real data i need are not inserted into excel.

Result in excel looks like this, thats all i can get from the page.
http://imageshack.us/photo/my-images...tedreport.jpg/

So I have ran macro again, when web page fully loaded i have tried to leftclick into real infomation area MANUALLY (just simple click into white area) and then used "SelectAll" command from macro again and it selected ONLY the real data which i could get into excel as i wanted. So here it is.

How can i "activate" information area by macro? In the source code of web page is no element where i could use .Click action so the area would activate it self and then i could use SelectAll command in my macro. Is there a way how to simulate by macro a simple leftclick somewhere into white area or basically everywhere under Controll Panel so "SelectAll" would select ONLY data below Control Panel?

I hope i described problem properly. If any unclear ill provide details. If source code of web page needed ill post it (really long) so i think would be better to post it as attached file(dunno if possible)...

Thank you for any help. I really can't get this solved at the moment=((