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.
slamondAsked:
Who is Participating?
 
slamondConnect With a Mentor Author Commented:
I solved the problem myself. On the Data ribbon there is a button labeled "From Web". Pasting the URL into that interface and then clicking GO and ultimately Import, it downloads the text into the cell of my choice. I then used the Developer ribbon's Record Macro button to document the steps in VBA (for later copying and pasting to the  Workbook_Open() subroutine as part of the automation process).
0
 
David FavorLinux/LXD/WordPress/Hosting SavantCommented:
This process tends to be far more complex than you might think.

https://www.experts-exchange.com/questions/29075321/how-to-store-some-selected-text-from-a-webpage-to-a-string-in-java.html - take a read through my comments about this process as a good starting point.
0
 
slamondAuthor Commented:
It works.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.