Import web table.

[wellsw]

I have played around with web query and other ways to bring table data from a web page into excel and am not happy with my current solutions.
i am Currently cut/pasting which works ok but my users constantly cut too much or too little.

since the web page is not consistent a standard web query will be less efficent than the cut/paste.

Is there a way to have excel select the table from the currently open web page copy it and paste into excel?