Logging web data excel

Excelneebie 1 Posts Tuesday January 9, 2018Registration date January 9, 2018 Last seen - Jan 9, 2018 at 02:08 PM - Latest reply: ac3mark 8621 Posts Monday June 3, 2013Registration dateModeratorStatus January 15, 2018 Last seen
- Jan 9, 2018 at 05:15 PM
I’m trying to log some data imported from the web. I’ve already managed to import the data as a table and set an auto refresh to every minute. What I now need is after an auto refresh, for each row of the data to appear in a separate sheet within the workbook and appear on the row below the last. This would mean that after one hour, I would have a series of sheets with 60 rows of data. I’d like to run it for a full day. I hope that makes sense. It must be possible but beyond my VBA skills. I’m very grateful for any advice.
See more 

3 replies

Reply to this topic
ac3mark 8621 Posts Monday June 3, 2013Registration dateModeratorStatus January 15, 2018 Last seen - Jan 9, 2018 at 04:56 PM
0
Helpful
2
That is not a free question. We are volunteers. I would recommend that you perform the follwoing, and go from here:

Write (record) a macro that take the current tab, copies it, and moves it to the end of the book.

Write a macro that starts a new tab. PLace the current data conection, onto the new tab.

Do that, and post back if you have any issues tieing them back together in a scheduled task!


Many thanks for your advice. When you say a new tab, do you mean a new sheet or a new cell? If I do that, it would do it once and not every time there is an auto refresh.
ac3mark 8621 Posts Monday June 3, 2013Registration dateModeratorStatus January 15, 2018 Last seen - Jan 9, 2018 at 05:15 PM
New sheet. The connection (which can be re-used), will keep moving with the sheet.
Respond to ac3mark