Saved Web Page into Excel
Assuming the file is .htm or .html
Right-click the file and:
Open With... Excel
Then, from the same instance of Excel,:
File Open yourfile
The copy/paste
--
Gary''s Student - gsnu200732
"Jez" wrote:
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
|