View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Grant[_4_] Grant[_4_] is offline
external usenet poster
 
Posts: 3
Default Date/Time data source refreshed function

How can this then link into the user clicking the Refresh button? Maybe I
could record the date/time of the last save of the workbook?

"Patrick Molloy" wrote in message
...
no
but why not just add a line of code like
ThisWorkbook.Names("UpdateTime").Value = Now
where UpdateTime is a named cell

--
Patrick Molloy
Microsoft Excel MVP
----------------------------------
"Grant" wrote in message
...
Is there a function that will output the date and time of the last

occurence
of a user refreshing a data source in Excel?

Thanks in advance for the replies,

Grant.