SAS excel macro

[varun45]

Is there a macro to find the last refreshed time of the excel sheet?

[RW9]

??  SAS Macros are not Excel macros.  So no, there is no SAS Macro to find something from another application.  You perhaps want to consult an Excel forum, e.g.

https://www.mrexcel.com/forum/excel-questions/106612-display-date-when-data-last-refreshed-external-...

Then save that refresh date in the date so you can read it in.

[varun45]

Hi,

Sorry,I am very new to this. Actually I am using excel with SAS add-in. I wanted to know the macro to find out the last refreshed time of the sheet. Can You help me in this?

[Kurt_Bremser]

Use the right tool (Maxim 14), which is VBA, the dedicated programming environment for MS Office. I don't know if SAS could retrieve that date in any way through dictionary.tables when a library is assigned to the Excel workbook.

[RW9]

I am afraid I don't use that.  What I would say is that is just a tool to pull data from a dataset, so its how that pull is done, and recording the datetime of that, e.g:

http://support.sas.com/kb/40/982.html

It would need to be stored in the datafile to be accessible, wouldn't think there is a property for that, but as I say I don't use.