Automatic Value Calculation
 

Hi,

I need to write an Add-In for Excel that can provide the following
functionality:

User enters into any cell a function call like [=GetQuote('IBM', 10)],
result being the cell's value updating with a new IBM's Stock Quote every 10
seconds.

Assuming I have the Quote data available, is this possible? What are the
best ways to do it in Excel.

The ultimate goal is to distribute an Add-in to users interested in this
functionality.

If possible, I do not want to depend on Cell's coordinate.

Thanks for any help.

- vlad

Automatic Value Calculation
 

Hi
have a look at the OnTime method to run a macro periodically:
http://www.cpearson.com/excel/ontime.htm

--
Regards
Frank Kabel
Frankfurt, Germany

"Vlad Zelenko" schrieb im Newsbeitrag
...
Hi,

I need to write an Add-In for Excel that can provide the following
functionality:

User enters into any cell a function call like [=GetQuote('IBM',
10)],
result being the cell's value updating with a new IBM's Stock Quote
every 10
seconds.

Assuming I have the Quote data available, is this possible? What are
the
best ways to do it in Excel.

The ultimate goal is to distribute an Add-in to users interested in
this
functionality.

If possible, I do not want to depend on Cell's coordinate.

Thanks for any help.

- vlad

Automatic Value Calculation
 

Thank you for the suggestion!

I guess I was not clear about what I need. My problem is updating a cell
dynamicly, not timer-driven execution of a method.

I suppose I could collect 'CurrentCell' references in an Array and update
their values based on parameter passed, but I was wondering if there is a
better way.

Thanks again.

"Frank Kabel" wrote in message
...
Hi
have a look at the OnTime method to run a macro periodically:
http://www.cpearson.com/excel/ontime.htm

--
Regards
Frank Kabel
Frankfurt, Germany

"Vlad Zelenko" schrieb im Newsbeitrag
...
Hi,

I need to write an Add-In for Excel that can provide the following
functionality:

User enters into any cell a function call like [=GetQuote('IBM',
10)],
result being the cell's value updating with a new IBM's Stock Quote
every 10
seconds.

Assuming I have the Quote data available, is this possible? What are
the
best ways to do it in Excel.

The ultimate goal is to distribute an Add-in to users interested in
this
functionality.

If possible, I do not want to depend on Cell's coordinate.

Thanks for any help.

- vlad

Automatic Value Calculation
 

Hi
never uses this but Excel has a feature called Web Query ('Tools -
Import External Data'). You can set a refresh for this query (Think 1
minute is the best you can do)

--
Regards
Frank Kabel
Frankfurt, Germany

"Vlad Zelenko" schrieb im Newsbeitrag
...
Thank you for the suggestion!

I guess I was not clear about what I need. My problem is updating a
cell
dynamicly, not timer-driven execution of a method.

I suppose I could collect 'CurrentCell' references in an Array and
update
their values based on parameter passed, but I was wondering if there
is a
better way.

Thanks again.

"Frank Kabel" wrote in message
...
Hi
have a look at the OnTime method to run a macro periodically:
http://www.cpearson.com/excel/ontime.htm

--
Regards
Frank Kabel
Frankfurt, Germany

"Vlad Zelenko" schrieb im Newsbeitrag
...
Hi,

I need to write an Add-In for Excel that can provide the
following
functionality:

User enters into any cell a function call like [=GetQuote('IBM',
10)],
result being the cell's value updating with a new IBM's Stock
Quote
every 10
seconds.

Assuming I have the Quote data available, is this possible? What
are
the
best ways to do it in Excel.

The ultimate goal is to distribute an Add-in to users interested
in
this
functionality.

If possible, I do not want to depend on Cell's coordinate.

Thanks for any help.

- vlad