Display File Attributes

[rlefranc42]

I want to link to an Excel file on the server and display the file attributes on the web page. eg Last Modified Date, Last Modified Time, Last Modified By, etc.

Does anyone know how to do this?

 

[Extentec]

Use the Scripting.FileSystemObject:

<%

Set oFS = Server.CreateObject(&quot;Scripting.FileSystemObject&quot
Set oFile = oFS.GetFile(&quot;C:/MyFile.xls&quot

Response.Write oFile.DateLastModified & &quot;<BR>&quot;
Response.Write oFile.DateCreated & &quot;<BR>&quot;
Response.Write oFile.DateLastAccessed & &quot;<BR>&quot;

Set oFile = Nothing
Set oFS = Nothing

%>

See Microsoft for the object model:

http://msdn.microsoft.com/library/en-us/script56/html/FSOoriFileSystemObject.asp

http://www.onti.net

 

[rlefranc42]

I tried placing the code in the body of my page and nothing happened. (Not even any errors.) Is it possible that the scripting .dll that the command calls isn't installed? I don't have access to check this on our server.

Thanks so much for your help.