Microsoft Office: Automating Excel

The behavior of the Office when you have multiple versions of Office  August 29, 2013 – 00:26
Microsoft Office Database

This article illustrates the logic according to which the Component Object Model (COM) determines which version of an Office application loaded when using Office Automation.

When a COM server is first installed or registered, and adds entries to the registry that match programmatic identifier (PROGID) and the class identifier (CLSID) of the server. These registry entries to enable COM to retrieve information related to a particular server, such as the location where the server is installed, to allow the user to automate this server. For example, Excel 2000 has the version-independent ProgID of Excel.Application and CLSID {00024500-0000-0000-C000-000000000046}. COM registry records for Excel 2000 are as follows: HKEY_CLASSES_ROOT \ Excel.Application \ CLSID
Default: {00024500-0000-0000-C000-000000000046}
\ LocalServer32 HKEY_CLASSES_ROOT \ CLSID \ {00024500-0000-0000-C000-000000000046} Default: C: \ PROGRA ~ 1 \ MICROS ~ 1 \ Office \ EXCEL.EXE / automation

When your computer has multiple versions of Office and using automation to one of the Office Server, version to be loaded is determined by these registry settings. In most cases, the rule is that the last installed version is the version that is loaded with the automation, however, presents a different behavior from other in Office Word applications. The following sections describe the different behaviors of each server automation of Office.

versions of Access, Excel, and PowerPoint 97, 2000, 2002, 2003 and 2007

Access, Excel, and PowerPoint, you can change these keys to the registry during the installation of Office. When you automate any of these applications, you load the latest version.

Word 97

Word 97 modifies these registry keys during the installation of Office. When you automate Word, if it is installed Word 2000 or Word 2002, Word 97 loads only if it is the latest version.

Word 2000, 2002, 2003 and 2007

Start Word 2000, 2002, 2003 AND 2007 change these keys to the registry during the installation of Office and every time. When you automate Word, the latest version is loaded initiated by the user or the latest version installed.

Additional Notes

A common perception for the automation of Office when you have multiple versions of Office installed on a system is that you can dictate the version is loaded using a version-dependent PROGID specific (for example, that "Excel.Application.9" Load Excel 2000, load the "Excel.Application.10" loads Excel 2002 and "Excel.Application.11" Office Excel 2003). This is not correct. Excel 2000 and later versions of Excel, you can share the same CLSID, so that the version that is loaded with these ProgID depends solely on which this was the last version.

For testing purposes, developers can force a specific version of an Office application to record using the / regserver command line. For example, to force a version to record without running the installer, you can use a command line similar to the following:

"C: \ program files \ microsoft office \ office \ excel.exe" / regserver

For more information about running multiple versions of Office or side-by-side installations of Office, click the following article in the Microsoft Knowledge Base article below:

Source: support.microsoft.com


35 weeks pregnant signs of labor
Microsoft Office Mac Home and Student 2011 - 1PC/1User [Download]
Digital Software (Microsoft)
  • Create visually rich newsletters, brochures, and more
  • Organize, analyze, and share your data and lists
  • Increase efficiency and save time by automating repetitive tasks
  • Simultaneously edit a file with multiple authors in different locations
  • Post, access, edit, and share your files from virtually anywhere

You might also like:

How to Create Fillable Forms in Microsoft Word 2010
How to Create Fillable Forms in Microsoft Word 2010
Excel VBA function for Nth Day Of Month - ExcelVBASql.com
Excel VBA function for Nth Day Of Month - ExcelVBASql.com
SQL Training Online - Excel to SQL Server - Part #5 - Automation
SQL Training Online - Excel to SQL Server - Part #5 - Automation

Future of VBA

I've learned a bit of VBA for Excel and have had some pretty good results with it at work - saving time, automating some things, and one general macro I created that briefly made me the office hero. I'd like to learn more about it but I read that Microsoft is trying to kill VBA. When do you think it will be phased out? Not sure if it makes sense to learn more about something that is going away. Anyone know?


check here

A novice's guide to backing up a PC  — ITProPortal
There's also an Outlook 2007/2003/2002 add-in from Microsoft called Personal Folders Backup that does just what it says. Follow these instructions from ..

Microsoft Software Office for Mac 2011 Home & Student -Family Pack (3Macs/3User) [Old Version]
Software (Microsoft Software)
  • Office for Mac Home and Student 2011 Family Pack includes Mac versions of Word 2011, Excel 2011 and PowerPoint 2011 English DVD,license qty: 3
  • The most familiar and trusted productivity applications used around the world at home, school, and business.
  • Reliable compatibility with the over 1 billion Macs and PCs running Office worldwide ensures you have the right tools to create, share
  • And collaborate with virtually anyone, anywhere with no worries
  • Office for Mac 2011 offers top-of-the-line software with the most complete feature set
Delete Duplicates in A Range using VBA -- ExcelVBASql.com 38
Delete Duplicates in A Range using VBA -- ExcelVBASql.com 38 ...
Microsoft Software Office Mac Home & Student 2011 Key Card (1PC/1User)
Software (Microsoft Software)
  • Licensed for one user for install on one Mac. Box inculudes one Product Key Card - No Disc
  • Office for Mac 2011 includes Mac versions of Word 2011, Excel 2011, and PowerPoint 2011; the most familiar and trusted productivity applications used around the...
  • Reliable compatibility with the over 1 billion Macs and PCs running Office worldwide ensures you have the right tools to create, share, and collaborate with virtually...
Microsoft Software Office for Mac Home & Student 2011 - 1 Pack [Old Version]
Software (Microsoft Software)
  • Office for Mac 2011 offers top-of-the-line software with the most complete feature set.
  • So you can deliver impressive, professional-looking documents and presentations.
  • PCs running Office worldwide ensures you have the right tools to create, share, and collaborate with virtually anyone, anywhere, with no worries.
  • Office Web App support: New Office Web Apps let you post, access, edit.
  • Share Office documents from where you want with nearly any computer with a browser;
  • Also includes Messenger for Mac 8 enabling you to communicate in real time with audio and video support.
  • And Remote Desktop for Mac 2 so you can drive your Windows-based PC from your Mac.
  • And coauthor a document with multiple people in multiple locations.
  • The most familiar and trusted productivity applications used around the world at home, school, and business.
Sybex Mastering VBA for Microsoft Office 2013
eBooks (Sybex)

Related posts:

  1. Microsoft Office Automation Security
  2. Microsoft Office Automation Word
  3. Microsoft Office automation.net

  • Avatar Smile! I wrote a whole essay yesterday and must not have saved it. Is there any possible way I can get it back?
    Dec 04, 2008 by Smile! | Posted in Other - Computers

    I do not want to write it again! There has to be a way. PLEASE HELP! I have Microsoft Office Word 2007

    • Not if you didnt save it sorry