Code or Formula?
 

I have multiple spreadsheets that pull data from a Sybase database.

I've set several of the sheets to refresh ever n minutes, and on open,
but would like to show on a summary sheet the time/date of the most
recent refresh.

Ideas? I'm suspecting it would be code rather than formula and I'm to
say the least a novice on code.

O.B.D.

Code or Formula?
 

I am not sure this will work, but its worth a try:

Setup a worksheet change event or calculate event macro to do the recording
see:

http://www.mvps.org/dmcritchie/excel/event.htm
--
Gary''s Student


"Oggie Ben Doggie" wrote:

I have multiple spreadsheets that pull data from a Sybase database.

I've set several of the sheets to refresh ever n minutes, and on open,
but would like to show on a summary sheet the time/date of the most
recent refresh.

Ideas? I'm suspecting it would be code rather than formula and I'm to
say the least a novice on code.

O.B.D.

Code or Formula?
 

There are no hard and fast rules, it depends on the requirement, and on the
amount of data, and what needs to done, but on balance, I would prefer
formulae, as they would normally out-perform VBA.

However, your particular case, needing to overwrite a value conditionally,
seems to require VBA. Usually, change events would handle it, but as you are
populating the cells via a data query, that will not trigger the change
event, so I think you will need to link a cell to one of those cells, and
test the values in the calculate event.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Oggie Ben Doggie" wrote in message
oups.com...
I have multiple spreadsheets that pull data from a Sybase database.

I've set several of the sheets to refresh ever n minutes, and on open,
but would like to show on a summary sheet the time/date of the most
recent refresh.

Ideas? I'm suspecting it would be code rather than formula and I'm to
say the least a novice on code.

O.B.D.

Code or Formula?
 

Thanks very much - you and the next post both indicate a change event is
the way to go so I'll dig into it. Thanks!

Oggie / Ben / ND




*** Sent via Developersdex http://www.developersdex.com ***

Code or Formula?
 

Thanks very much - you and the previous poster both indicated a change
event is the way to go so I'll dig into it. Thanks!

Oggie / Ben / ND

Sorry for the "form" reply :-)

*** Sent via Developersdex http://www.developersdex.com ***