SONTAYA'P BLOGGER

IT Digital lifestyle

sage accpac office automation when multiple versions

bySONTAYA January 16, 2015 Office

Collapse image SUMMARY

This article discusses and explains how COM (Component Object Model) determines which version of an Office application is loaded when you use Office Automation.

Collapse image MORE INFORMATION

When a COM server is first installed or registered, it adds entries to the registry that correspond with the server’s programmatic identifier (PROGID) and class identifier (CLSID). These registry settings allow COM to retrieve information about a server, such as where the server is installed, and enables you to automate the server. To illustrate, Excel 2000 has the Excel.Application version-independent PROGID and the {00024500-0000-0000-C000-000000000046} CLSID. COM related registry entries for Excel 2000 include the following:

HKEY_CLASSES_ROOT\Excel.Application\CLSID
Default Value: {00024500-0000-0000-C000-000000000046}
HKEY_CLASSES_ROOT\CLSID\{00024500-0000-0000-C000-000000000046}\LocalServer32Default Value: C:\PROGRA~1\MICROS~1\Office\EXCEL.EXE /automation

By following the registry keys from the PROGID to the CLSID, COM can learn where the Excel executable file is installed and start it for Automation.

When you have multiple versions of Office installed and you use Automation to one of the Office servers, the version that loads is governed by these settings in the registry. For the most part, the rule is that the last version that was installed is the version that loads with Automation; however, Word exhibits behavior that differs from the other Office applications. The different behaviors for each of the Office Automation servers are described in the following sections.

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

Access, Excel, and PowerPoint modify these registry keys during Office setup. When you automate one of these applications, the version that is loaded is the version that was last installed.

Word 97

Word 97 modifies these registry keys during Office setup. When you automate Word, if either Word 2000 or Word 2002 are installed, Word 97 loads only if it was the last version installed.

Word 2000, 2002, 2003, and 2007

Word 2000, 2002, 2003 and 2007 modify these registry keys during Office setup and each time Word starts. When you automate Word, the version that is loaded is the version that was last started by the user or the version that was last installed.

Additional Notes

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

For testing purposes, developers can force a specific version of an Office application to register by using the /regserver switch on the command line. For example, to force an Excel version to register without running setup, you can use a command line that resembles the following:

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

Although you can implement this switch for testing and development purposes, it is not recommended that you rely on this switch in production scenarios.

For additional information about running multiple Office versions, or side-by-side Office installations, click the following article number to view the article in the Microsoft Knowledge Base:

290576 OFFXP: Running Multiple Versions of Microsoft Office

Step by step;

1. Install Windows 7 64bit

2. Install ACCCPAC Software

3. Install MS Office 2013 32bit

4. Install MS Office 2003 32bit

Finished!
———————————————————-
Note: ACCPAC HKEY_CLASSES_ROOT For verify…HKEY_CLASSES_ROOT\Wow6432Node\CLSID\{00024500-0000-0000-C000-000000000046}\LocalServer32

Before;
C:\PROGRA~2\MICROS~1\Office15\EXCEL.EXE /automation

After; installed MS Office 2003
C:\PROGRA~2\MICROS~1\OFFICE11\EXCEL.EXE /automation

———————————————————
; To restart windows and then test GL > Financial Reporter > Statement Designer

———————————————————
Note:  “error 429/problem in running financial reporter addin”

//answers.microsoft.com/en-us/office/forum/office_2007-customize/error-429problem-in-running-financial-reporter/f6bc20ae-965e-412b-a274-ca916a4769ca

​ACCPAC by performing the following steps.

Open Excel.
Select Add-Ins from the Tools menu.
Click the Browse button and browse to the General Ledger program directory. For example, if version 5.5 of Sage
Accpac ERP is installed, the accpacfrXXX.xla file will be located in the [accpac]\GL55A folder (where [accpac] is the directory where Sage Accpac ERP is installed. By default, this directory is C:\Program Files\Sage Software\Sage Accpac.)
Once in the proper directory, select accpacfr550.xla and click OK.
Select the checkbox beside the entry in the Add-Ins window for the file added in the previous
step and click OK to close the Add-Ins window.

Taggedaccpac

7 สิ่งที่คุณต้องรู้เกี่ยวกับบริษัท Calico ของ Google "คุณต้องมีชีวิตอยู่ตลอดไป"

ขายเครื่องสำอางค์ บน Facebook Fanpage!

Leave a Reply Cancel reply

You must be logged in to post a comment.

Tag Cloud

3G Android Backup Blognone Chromecast Cloud Comparison CUPS Dell DNS Facebook Firefox Firewall Google Guitar Hacked HP Joomla LGP500 LibreOffice Linux Mozilla Firefox OpenOffice.org Open Source OpenStack openSUSE openSUSE11.3 openSUSE12.1 Peplink Performance Postfix Printer Samsung Security Storage SUSE SUSE Enterprise Desktop SUSE Enterprise Server SUSE Linux Enterprise Switch Thin client Tips VMware WordPress WordPress/SMF

Comments

  • Narupon Pattapat on การ cleaning the imaging unit หรือ Drum (Imaging Unit)
  • 76Rusty on แอพ aVia Media Player Pro และ Pocket Casts 4 อนาคตอาจรองรับ Chromecast
  • JindaTheme on CloudFlare คืออะไร?
  • viva3388 on CloudFlare คืออะไร?
  • SONTAYA on Linux Foundation T-Shirt มาแล้ว

Categories

  • Android (7)
  • Joomla (9)
  • LibreOffice/OpenOffice.org (16)
  • Linux (159)
  • Music (16)
  • News (55)
  • Office (55)
  • Online Marketing (3)
  • Personal (232)
  • VMware (5)
  • WordPress/SMF (20)

Archives

  • May 2019
  • March 2019
  • January 2019
  • December 2018
  • September 2018
  • August 2018
  • July 2018
  • April 2018
  • March 2018
  • January 2018
  • December 2017
  • June 2017
  • December 2016
  • November 2016
  • April 2016
  • March 2016
  • February 2016
  • September 2015
  • August 2015
  • July 2015
  • June 2015
  • May 2015
  • April 2015
  • February 2015
  • January 2015
  • November 2014
  • October 2014
  • September 2014
  • August 2014
  • July 2014
  • June 2014
  • May 2014
  • April 2014
  • March 2014
  • February 2014
  • December 2013
  • November 2013
  • October 2013
  • September 2013
  • August 2013
  • July 2013
  • June 2013
  • May 2013
  • April 2013
  • March 2013
  • February 2013
  • January 2013
  • December 2012
  • November 2012
  • October 2012
  • September 2012
  • August 2012
  • June 2012
  • May 2012
  • April 2012
  • March 2012
  • February 2012
  • December 2011
  • November 2011
  • October 2011
  • September 2011
  • August 2011
  • July 2011
  • June 2011
  • May 2011
  • April 2011
  • March 2011
  • February 2011
  • January 2011
  • December 2010
  • November 2010
  • October 2010
  • September 2010
  • August 2010
  • July 2010
  • June 2010
  • May 2010
  • April 2010
  • March 2010
  • February 2010
  • January 2010
  • December 2009

Archives

  • May 2019 (1)
  • March 2019 (1)
  • January 2019 (1)
  • December 2018 (1)
  • September 2018 (1)
  • August 2018 (3)
  • July 2018 (1)
  • April 2018 (1)
  • March 2018 (1)
  • January 2018 (2)
  • December 2017 (1)
  • June 2017 (3)
  • December 2016 (1)
  • November 2016 (1)
  • April 2016 (1)
  • March 2016 (2)
  • February 2016 (1)
  • September 2015 (3)
  • August 2015 (2)
  • July 2015 (7)
  • June 2015 (5)
  • May 2015 (1)
  • April 2015 (1)
  • February 2015 (2)
  • January 2015 (1)
  • November 2014 (3)
  • October 2014 (2)
  • September 2014 (2)
  • August 2014 (1)
  • July 2014 (3)
  • June 2014 (3)
  • May 2014 (2)
  • April 2014 (5)
  • March 2014 (2)
  • February 2014 (5)
  • December 2013 (3)
  • November 2013 (15)
  • October 2013 (15)
  • September 2013 (11)
  • August 2013 (9)
  • July 2013 (26)
  • June 2013 (7)
  • May 2013 (15)
  • April 2013 (6)
  • March 2013 (5)
  • February 2013 (4)
  • January 2013 (2)
  • December 2012 (9)
  • November 2012 (2)
  • October 2012 (4)
  • September 2012 (2)
  • August 2012 (4)
  • June 2012 (3)
  • May 2012 (4)
  • April 2012 (6)
  • March 2012 (14)
  • February 2012 (9)
  • December 2011 (8)
  • November 2011 (6)
  • October 2011 (13)
  • September 2011 (7)
  • August 2011 (10)
  • July 2011 (4)
  • June 2011 (12)
  • May 2011 (26)
  • April 2011 (6)
  • March 2011 (3)
  • February 2011 (4)
  • January 2011 (10)
  • December 2010 (6)
  • November 2010 (4)
  • October 2010 (5)
  • September 2010 (10)
  • August 2010 (5)
  • July 2010 (8)
  • June 2010 (6)
  • May 2010 (4)
  • April 2010 (9)
  • March 2010 (10)
  • February 2010 (8)
  • January 2010 (21)
  • December 2009 (28)
Proudly powered by WordPress | Theme: Showme by NEThemes.