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.

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.

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.

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 ***

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 ***