Update Data feeds through macro

**ChrisNor** · 03-13-2009, 08:05 AM

I've made a macro that pulls out the data of the data feed sheets (from an external website). And stores them in a seperate sheet.

However I need to make sure that the external data feed is updated before the macro is run. How can I do this?

A second issue is auto running the macro once a day... Do I need to open or keep the excel sheet open for the macro to run at set intervals? Or can I get the macro to run without having to open Excel or the spesific spreadsheet/workbook?

**royUK** · 03-13-2009, 08:17 AM

What sort of data feed is it, how is it currently run? Does it use Get External Data from the data menu?

The macro can be timed but it would really need the workbook to be opened.

**ChrisNor** · 03-13-2009, 08:19 AM

Yeah it used Get External Data from Website/table

**royUK** · 03-13-2009, 09:03 AM

Something like this will refresh the query table

Please Login or Register  to view this content.

You can run your code automatically using the OnTime method which a search of the Forum should produce many examples.

You would need windows scheduler or something to automatically open the worksheet.