I got this request from a customer who is trying to analyze their environment as it pertains to Access and Excel files: Can we use WSH and VBScript to get this type of basic information out of files in an automated fashion? Both MS Access and Excel have a well defined object model i.e. it should be easy to write a script that opens the file,
Microsoft Office Professional Plus 2007, queries the various collection objects, and dumps the contents (e.g. Table Names in Access,
Office 2007 Professional Plus Key, Pivot Table objects in excel,
Office 2010 Pro, Data source names in either etc for Excel and Access 2000)? The Office migration planner has some really good tools for understanding what is in your organization. Here is a description of the tool: The Office Migration Planning Manager (OMPM) is a collection of tools that enables you to prepare your environment for migration to the 2007 Microsoft Office system. OMPM checks for,
Cheap Office 2010, and reports on, file properties to help you analyze your environment and determine any issues that you might experience converting from Office 97-Office 2003 file formats to the new 2007 Office system file format. Enjoy,
Windows 7 64bit! <div