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)

---------------------------------
Already_Open_Scenario:
LVersion =
Split(ActiveWorkbook.BuiltinDocumentProperties("Subject").value, ".")

On Error GoTo noVersionStamp
LfileFormat = LVersion(0) & LCMVersion(1)
On Error GoTo 0

Select Case LfileFormat
Case Is = 41
If verifySheet(fromWorkbook) Then Call
importSheets_41(fromWorkbook, toWorkbook, selectedFile)
--------------------------------