Bot am I glad you solved this one!!!! Good work, good work. ;) Michael and Judith!!!! This is a fantastic post for FA!!!!
Erika With a K ------------------------------------------------------------ >>| -----Original Message----- >>| From: Hatton Humphrey [mailto:[EMAIL PROTECTED]] >>| Sent: Thursday, July 11, 2002 4:05 PM >>| To: CF-Community >>| Subject: Re: Excel COM Object or CFObject Tag Directly >>| Linked to Hair Loss >>| >>| >>| UPDATE >>| ------ >>| >>| Bald Man Fixes COM Problems, Praises TechNet >>| Amherst, NY: After spending several frustrating hours >>| attpempting to >>| correct the issue with COM object access, Hatton's Network >>| Administrator, John Morris, finally found and implemented the fix. >>| >>| When interviewed, the only two things he would say were, >>| "Who da man!?!" >>| and "Why didn't I think of that..." >>| >>| John recently shaved his head in memory of a friend who >>| recently died >>| from cancer. >>| >>| The process, a 19 step nightmare, is included with this release for >>| anyone who might experience the same problem: >>| >>| ------------------------------------------------------------------- >>| 1. Log on to the computer as the Administrator and create a >>| new user >>| account that will automate Office. In our example, this >>| account is named >>| OfficeAutomationUser . Create a password for this user account, and >>| select Never expire so that the password does not have to >>| be changed. >>| >>| 2. Add the OfficeAutomationUser account to the Administrators group. >>| >>| 3. Log in to the computer as OfficeAutomationUser and install (or >>| reinstall) Office using a complete install. For system >>| robustness it is >>| recommended that you copy the contents of the Office CD to >>| a local drive >>| and install Office from this location. >>| >>| 4. Start the Office application that you intend to >>| automate. This forces >>| the application to register itself. >>| >>| 5. After the application is running, press ALT+F11 to load >>| the Microsoft >>| Visual Basic for Applications (VBA) editor. This forces VBA to >>| initialize itself. >>| >>| 6. Close the applications, including VBA. >>| >>| 7. On the taskbar, click Start , click Run , and then type >>| DCOMCNFG . >>| Select the application that you want to automate. The >>| application names >>| are listed below: >>| Microsoft Access 97 - Microsoft Access Database >>| Microsoft Access 2000/2002 - Microsoft Access Application >>| Microsoft Excel 97/2000/2002 - Microsoft Excel Application >>| Microsoft Word 97 - Microsoft Word Basic Microsoft Word >>| 2000/2002 - Microsoft Word Document Click Properties to >>| open the property dialog box for this application. >>| >>| 8. Click the Security tab. Verify that Use Default Access >>| Permissions >>| and Use Default Launch Permissions are selected. >>| >>| 9. Click the Identity tab. Select This User and type the >>| username and >>| password for OfficeAutomationUser . >>| >>| 10. Click OK to close the property dialog box and return to >>| the main >>| applications list dialog box. >>| >>| 11. In the DCOM Configuration dialog box, click the Default >>| Security tab. >>| >>| 12. Click Edit Defaults for access permissions. Verify that the >>| following users are listed in the access permissions, or >>| add the users >>| if they are not listed: >>| SYSTEM >>| INTERACTIVE >>| Everyone >>| Administrators >>| OfficeAutomationUser >>| IUSR_<machinename> * >>| IWAM_<machinename> * >>| >>| * These accounts only exist if Internet Information Server (IIS) is >>| installed on the computer. >>| >>| 13. Make sure that each user is allowed access and click OK . >>| >>| 14. Click Edit Defaults for launch permissions. Verify that the >>| following users are listed in the launch permissions, or >>| add the users >>| if they are not listed: >>| SYSTEM >>| INTERACTIVE >>| Everyone >>| Administrators >>| OfficeAutomationUser >>| IUSR_<machinename> * >>| IWAM_<machinename> * >>| >>| * These accounts only exist if IIS is installed on the computer. >>| >>| 15. Make sure that each user is allowed access and click OK . >>| >>| 16. Click OK to close DCOMCNFG. >>| >>| 17. Start REGEDIT and verify that the following keys and >>| string values >>| exist for the Office application that you want to automate: >>| Microsoft Access 97: >>| Key: HKEY_CLASSES_ROOT\AppID\MSACCESS.EXE >>| AppID: {8CC49940-3146-11CF-97A1-00AA00424A9F} >>| >>| Microsoft Access 2000/2002: >>| Key: HKEY_CLASSES_ROOT\AppID\MSACCESS.EXE >>| AppID: {73A4C9C1-D68D-11D0-98BF-00A0C90DC8D9} >>| >>| Microsoft Excel 97/2000/2002: >>| Key: HKEY_CLASSES_ROOT\AppID\EXCEL.EXE >>| AppID: {00020812-0000-0000-C000-000000000046} >>| >>| Microsoft Word 97/2000/2002: >>| Key: HKEY_CLASSES_ROOT\AppID\WINWORD.EXE >>| AppID: {00020906-0000-0000-C000-000000000046} >>| >>| If these keys do not exist, you can create them by running >>| the following >>| reg file on your system: >>| REGEDIT4 >>| [HKEY_CLASSES_ROOT\AppID\WINWORD.EXE]"AppID"="{00020906-0000 >>| -0000-C000-000000000046}" >>| [HKEY_CLASSES_ROOT\AppID\EXCEL.EXE]"AppID"="{00020812-0000-0 >>| 000-C000-000000000046}" >>| [HKEY_CLASSES_ROOT\AppID\MSACCESS.EXE]"AppID"="{73A4C9C1-D68 >>| D-11D0-98BF-00A0C90DC8D9}" >>| NOTE : The sample .reg file is for Access 2000 or Access >>| 2002. If you >>| are using Access 97, change the AppID key to: >>| "AppID"="{8CC49940-3146-11CF-97A1-00AA00424A9F}" >>| >>| 18. To avoid registry conflicts, install and run an NT >>| service. Set the >>| identity of the service to run as OfficeAutomationUser , and select >>| Automatic as the startup type. For more information on >>| creating a sample >>| Visual C++ NT Service, see the following Microsoft >>| Developer Network >>| (MSDN) Web site: >>| Creating a Simple Win32 Service in C++ >>| http://msdn.microsoft.com/library/techart/msdn_ntservic.htm >>| >>| 19. Restart the system. This is required. >>| ------------------------------------------------------------------- >>| >>| Hatton Humphrey wrote: >>| >>| > Amherst, NY: Software developer Hatton Humphrey has a >>| problem. He's >>| > loosing his hair, and at an alarming rate. >>| > >>| > "Before I tried messing with this ColdFusion stuff I was >>| your average >>| > developer. Sure, I'd run into different problems here >>| and there, but >>| > never something of this magnitude," Hatton said when >>| asked what the >>| > source of his woes were. >>| > >>| > "Now I'm trying to provide something nice for a client and use >>| > Microsoft >>| > Excel to give them a downloadable list of items. It will >>| work in one >>| > environment but not the other." >>| > >>| > Exasserbated, Hatton has turned to his network administrator and a >>| > popular COM website, cfcomet.com. Using these resources >>| he has, "tried >>| > every option, thought or suggestion," to no success. >>| > >>| > In response to the elevated levels of stress, Hatton's >>| hairline has >>| > responded by accelerating it's rate of recession. If >>| things don't work >>| > out soon he may need to invest in Rogaine or one of the nicer >>| > non-prescription hair growth formulas. >>| > >>| > In a desparate plea for help, Hatton is sending out requests for >>| > assistance to fellow ColdFusion developers. >>| > >>| > "I've checked users permissions, created a new local user >>| and assigned >>| > it to run the server... even reinstalled Excel at one >>| point in time. >>| > None of it seems to make any difference. I keep getting >>| 'Error trying >>| > to create object specified in the tag. COM error >>| 0x80070005. Access is >>| > denied.' messages. I guess there are still things that >>| I'm missing here." >>| > >>| > Anyone with information relating to this problem is encouraged to >>| > respond to posts and reposts of this message. The system >>| in question is >>| > running Windows 2000 and IIS 5.0 with Microsoft Excel >>| 2000 installed. >>| > >>| > "Please, any advice will help at this stage! I don't >>| want to be bald >>| > before my daugther walks!" >>| > >>| > >>| > >>| ______________________________________________________________________ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
