Solved

Getting File Creation Date

Posted on 2002-03-21
3
167 Views
Last Modified: 2010-05-02
I have 4 files that I want to update in my C:\winnt\system32 directory.  The file dates of the old files are 1/20/2000 and the new file dates are 1/20/2002.  There are only 4 files to replace, but I want only replace these files with the new dated files.  How can I test for date on the file?
0
Comment
Question by:mtbuford
  • 2
3 Comments
 
LVL 18

Accepted Solution

by:
bobbit31 earned 50 total points
ID: 6886831
you could use fso:

   Set fs = CreateObject("Scripting.FileSystemObject")
   Set f = fs.GetFile("C:\windows\desktop\copy of Calc.doc")
   msgbox f.DateCreated
   msgbox f.DateLastAccessed
   msgbox f.DateLastModified
0
 
LVL 18

Expert Comment

by:bobbit31
ID: 7537326
why the 'C'?
0
 
LVL 6

Expert Comment

by:Mindphaser
ID: 7545790
Changed grade per request.

mtbuford

If you didn't get enough information feel free to ask the experts any further questions. Take a look at http://www.experts-exchange.com/jsp/cmtyQuestAnswer.jsp to read more about grading.

** Mindphaser - Community Support Moderator **
0

Featured Post

Master Your Team's Linux and Cloud Stack!

The average business loses $13.5M per year to ineffective training (per 1,000 employees). Keep ahead of the competition and combine in-person quality with online cost and flexibility by training with Linux Academy.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Vb.net 2008 2 60
consolidate or create a new vba code for performing tasks 5 66
Passing a Text Box name to a Sub 6 96
Create Files based on Cell Values in a Range in Excel 12 40
Introduction I needed to skip over some file processing within a For...Next loop in some old production code and wished that VB (classic) had a statement that would drop down to the end of the current iteration, bypassing the statements that were c…
If you have ever used Microsoft Word then you know that it has a good spell checker and it may have occurred to you that the ability to check spelling might be a nice piece of functionality to add to certain applications of yours. Well the code that…
Get people started with the process of using Access VBA to control Excel using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Excel. Using automation, an Access application can laun…
This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code. This l…

810 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question