Auto Refresh Incoming Data From Another Source

[Hajik]

Hi,

I have connected an excel file to a csv. Csv updates every second, but the lowest time possible for the excel file to refresh is 1 minute. I need the data to be imported less than a minute. For eg 5 seconds or 3 seconds. I guess I need a macro to refresh excel import every 3 or 5 seconds.

Thanks in advance.

[kieranbop]

I'm working on something very similar to this also

Please Login or Register  to view this content.

something like that would work, so similar to sleep in scripts, excel vba uses the wait command

[Hajik]

It didn't work. Is it possible to write a macro to automatically push refresh button in data tab every 3 seconds?
This button works manually. I guess a macro can activate this button automatically and so we get a refresh.

[Hajik]

Ok solved it with the help of dear kieranbop.
Came back to give the complete answer in case anyone would need this in future.

Create a Module and type this in it:

Please Login or Register  to view this content.

In workbook type this:

Please Login or Register  to view this content.

And at last type this in your current sheet.

Please Login or Register  to view this content.