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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How can I show the file modification date in a page header? 1
Protecting a header/footer 3
Excel file modification date 5
Filename in Excel Cell Address 7
Dates-Automatically entered in cells 7
Automatically adding last modification date to footer 1
dates question 2
How do I enter the contents of a cell into a page header 1

Back
Top