Logging Excel Data Feeds

tmh88

Hi guys,

I need some help with a project I'm working on. Is there anyway to have Excel to record data from an XML feed into a new row each time it is updated?

To make things very simple, say I had an xml feed that just updated a random number every few minutes. Say minute 1 the feed's output was a 3. So I'd like Excel to record the 3 into row 1 column A. Minute 2's output was 38, so I'd like that to be recorded into row 2 column A. Do I need to write a macro to do this if it's possible at all?

Thanks

tmh88

I finally figured it out after an hour or so of playing around. I first recorded a macro of the keystrokes that I wanted to be performed, then I found a few tutorials that help you to write a macro which automatically runs a macro at designated time intervals.

It took me a while to find a tutorial that was close to what I wanted to do. Most of them just gave the code but didn't say how it was supposed to be implemented regarding the different modules or references to other modules.