Logo 
Search:

MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Obtaining the date modified property of a file from within Excel VBA

  Asked By: Durril    Date: Oct 31    Category: MS Office    Views: 1729
  

I'm trying to put together a quick piece of VBA that runs down a list
of Excel workbooks and for each picks up the time at which it was last
modified. I see there's a lastupdated property but don't understand
how to use it.

Any ideas?

Share: 

 

1 Answer Found

 
Answer #1    Answered By: Adalwin Fischer     Answered On: Oct 31

Here is a piece of code that will show you how to use the document
properties. To find the specific one you are looking for, search in the
VBE object model. We write a version number of the model that created a
specific workbook, and then, when importing, check what version the
workbook is, so we can import it correctly.

In terms of going to a specific folder, and then trolling through the
workbooks in the folder, visit the following links:
http://www.vba-programmer.com and
http://www.exceltip.com/excel_tips/Files,_Workbook,_and_Worksheets_in_VB
A/203.html and http://www.cpearson.com/excel/topic.htm (look for folder)

 




Tagged: