Auto refresh ODBC data

[popov_ae]

Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Hallo,

I import data to excel spreadsheet via ODBC (market quotes from trade terminal) How can I make this data refresh automatically (for example every 1 minute) because now the data refreshes only if i push "Refresh all" button?

Thank you for your answer and sorry for my English)

 

[John McGhie]

You can't. It will refresh automatically when you open the Excel
spreadsheet. But otherwise, you need to write a VBA or AppleScript program
to force updates. I doubt that AppleScript will do this easily, and Office
2008 has no VBA.

I think you need to wait for the next version of Office, due out at the end
of this year, or go back to the old version (2004).

Hope this helps

Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Hallo,

I import data to excel spreadsheet via ODBC (market quotes from trade
terminal) How can I make this data refresh automatically (for example every 1
minute) because now the data refreshes only if i push "Refresh all" button?

Thank you for your answer and sorry for my English)

This email is my business email -- Please do not email me about forum
matters unless you intend to pay!

 

[Jim Gordon Mac MVP]

Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Hallo,

I import data to excel spreadsheet via ODBC (market quotes from trade
terminal) How can I make this data refresh automatically (for example
every 1 minute) because now the data refreshes only if i push "Refresh
all" button?

Thank you for your answer and sorry for my English)

Later this year, when Excel 2011 becomes available, you will be able to
create a VBA add-in that does exactly as you requested.

-Jim