Modification Date

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hey people. Is there any way to insert the file modification date into a cell
or a header/footer in Excel 2002?
 
Hey people. Is there any way to insert the file modification date into a cell
or a header/footer in Excel 2002?
Click to expand...

Hello Chris,

Just change the the variable FIlename to a string that includes the
file path and name of the file you want the Last Modified date for.
Then assign the variable LastModified to a cell, header, footer, etc.

Dim FSO As Object
Dim LastModified
Filename="c:\Program Files\Test.xls"
Set FSO = CreateObject("Scripting.FileSystemObject")
LastModified = FSO.GetFile(filename)

Sincerely,
Leith Ross
 
Thank's so much.

Leith Ross said:
Hello Chris,

Just change the the variable FIlename to a string that includes the
file path and name of the file you want the Last Modified date for.
Then assign the variable LastModified to a cell, header, footer, etc.

Dim FSO As Object
Dim LastModified
Filename="c:\Program Files\Test.xls"
Set FSO = CreateObject("Scripting.FileSystemObject")
LastModified = FSO.GetFile(filename)

Sincerely,
Leith Ross
Click to expand...
 
Back
Top