I have a database system at work that only allows the printing of a report query or saving as a web page. I need to be able to add this data into other things. So if I save the report as a web page, how can I import that into excel?

I am looking for some vba code that would import the web page onto a specific worksheet and this would enable me to take data from it and produce my own report.

Jez

JezLisle,

I have just begun to learn the coding process, so I'm not an expert at it, but you can probably do what you're need through the menus....

Data>Import

the 'Import Data' function or 'New DB query' function should work.
I assume it would just be like performing a Web Query (importing a web table, like financial data). Just browse your file. You can do HTML's, no problem.