 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Links / July 2008Displaying File Timestamp of Another Excel File
I have a link from an external Excel file displaying data within my (current) Excel file. To make sure I am pulling the latest version of the data and displaying the timestamp of that latest data, is there a way to display the timestamp of that external file within my (current) spreadsheet? Many thanks.... (previously posted to microsoft.public.excel.charting) Put this in a standard module in your workbook: Function FileDate(FileName As String) As Date Application.Volatile FileDate = FileDateTime(FileName) End Function Put this in a cell in a worksheet in your workbook =FileDate("C:\Temp\MyFile.xls") [amend as appropriate] Bill Manville MVP - Microsoft Excel, Oxford, England No email replies please - respond to newsgroup > Put this in a standard module in your workbook: > [quoted text clipped - 5 lines] > Put this in a cell in a worksheet in your workbook > =FileDate("C:\Temp\MyFile.xls") [amend as appropriate] Thanks, Bill, but for some reason I get a "#NAME?" error after pasting the function in the VB editor for that sheet, and putting the "=FileDate()" in a cell in my workbook. Suggestions? I am in an office with MS Office permissions tightly controlled, so I cannot download add-ins or install new software without Helpdesk intervention. Did you put the function in a General module? Did you allow macros to run when you opened the workbook? And you did really put the full path to the other file in your formula, right? =FileDate("C:\Temp\MyFile.xls") > > Put this in a standard module in your workbook: > > [quoted text clipped - 14 lines] > download add-ins or install new software without Helpdesk > intervention.  SignatureDave Peterson |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.