AwfulSpider
New Member
- Joined
- Sep 25, 2020
- Messages
- 15
- Office Version
- 365
- Platform
- Windows
Hello!
I have a frustratingly repetitive task I'd like to automate. Every morning I'm sent a .html file that contains thousands of rows of info. Unfortunately, the link only carries 250 rows per page, so I copy/paste through each page into an excel file. The file looks like this:
With the three things in green changing by month, day(.sometimes there's 1 or 2 files), and page # respectively.
I was able to use the Get From Web tool to automatically put 1 page at a time into a table, rather than copy/paste, but this doesn't really save time since I have to change the page number in the file link and repeat the process.
I was trying to use VBA to automate the process, but am very much a novice. I've been unable to automate a query that counts up through the pages....
any help is much appreciated!!
I have a frustratingly repetitive task I'd like to automate. Every morning I'm sent a .html file that contains thousands of rows of info. Unfortunately, the link only carries 250 rows per page, so I copy/paste through each page into an excel file. The file looks like this:
file:///C:/Users/33887216/Desktop/QI%20Work/Jabber/FinesseDaily/January/ContactTracerDailyReport14.1/AdvancedCDRReport__1.htm |
With the three things in green changing by month, day(.sometimes there's 1 or 2 files), and page # respectively.
I was able to use the Get From Web tool to automatically put 1 page at a time into a table, rather than copy/paste, but this doesn't really save time since I have to change the page number in the file link and repeat the process.
I was trying to use VBA to automate the process, but am very much a novice. I've been unable to automate a query that counts up through the pages....
any help is much appreciated!!