Scott Lamond
asked on
Capturing a Webpage As Text and Importing Into Excel.
Using Windows Task Scheduler and a series of batch files that download reports (as CSV files) I'm able to automate the hourly updating of macro-enabled Excel files that auto-publish their reports as HTM files to a webserver. But I've hit a brickwall since one of the webpages from which I need data is only presented as a webpage (no downloadable report available). I see the obvious solution as capturing the page as text (manually I'd do it using <Ctrl>+<A>, <Ctrl>+<C> and pasting the text into Excel for manipulation). But I'm not familiar with how to accomplish this automatically, in Excel or otherwise.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
It works.
https://www.experts-exchan