Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Durril Jansen   on Oct 31 In MS Office Category.

  
Question Answered By: Adalwin Fischer   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)

Share: 

 
 


Tagged: