Error when running a powershell script

Question

Error when running a powershell script

Pamu 91

Hi everyone, When I try to run this poweshell script .. it gives the error saying

New-Object : Retrieving the COM class factory for component with CLSID {00000000-0000-0000-0000-000000000000} failed due to the following error: 80040154 Class not 
registered (Exception from HRESULT: 0x80040154 (REGDB_E_CLASSNOTREG)).

At C:\Users\user1\Desktop\ClientSubmissionDetail.ps1:27 char:20
+ $excelObject = New-Object -ComObject Excel.Application

+ CategoryInfo          : ResourceUnavailable: (:) [New-Object], COMException
 + FullyQualifiedErrorId : NoCOMClassIdentified,Microsoft.PowerShell.Commands.NewObjectCommand

The property 'Visible' cannot be found on this object. Verify that the property exists and can be set.
At C:\Users\user1\Desktop\ClientSubmissionDetail.ps1:28 char:5
+     $excelObject.Visible = $false
+     ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo          : InvalidOperation: (:) [], RuntimeException
    + FullyQualifiedErrorId : PropertyNotFound

The error go on like this Can anyone please help ?

3 answers

Your answer

Answer 1

Anonymous

Hi，

Is Microsoft Office installed? If yes you can try to repair it.

Repair an Office application
https://support.microsoft.com/en-us/office/repair-an-office-application-7821d4b6-7c1d-4205-aa0e-a6b40c5bb88b

Best Regards，
Ian

============================================

If the Answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Pamu 91 Reputation points

2020-11-19T08:46:47.917+00:00

Yes .. Office is installed. It's Office365 64-bit.
and I did a repair to Office. As it didn't work, I uninstalled and reinstalled Office once more. but the same error comes.
Anonymous

2020-11-20T05:17:58.993+00:00

How about registering Microsoft.Office.Interop.Excel.dll manually with Regasm.exe?
Pamu 91 Reputation points

2020-11-21T02:00:52.213+00:00

Could you please help me with that? How to do that?
Anonymous

2020-11-23T06:20:56.257+00:00

Here you go
https://learn.microsoft.com/en-us/dotnet/framework/tools/regasm-exe-assembly-registration-tool

Answer 2

Rich Matheisen 47,901

Are you running the script from PowerShell, the ISE, or some other place?

Try placing this at the beginning of your script and see if you're running the 64 or 32 bit version of Powershell:

[Environment]::Is64BitProcess

It may be that you're trying to use a 64-bit DLL from a 32-bit process and the registration of the DLL isn't in the right part of the registry.

Pamu 91 Reputation points

2020-11-22T10:29:27.063+00:00

in the ISE
and tried both 32 and 64 bit
the same error
Rich Matheisen 47,901 Reputation points

2020-11-22T19:13:08.873+00:00

Do you find the registry key for Excel.Application?

If you do, what is the value of the CLSID? HKEY_CLASSES_ROOT\Excel.Application\CLSID

If you do, do you find the corresponding registry key HKEY_CLASSES_ROOT\WOW6432Node\CLSID{00024500-0000-0000-C000-000000000046} (where the value between the "{" and "}" match the same CLSID?

How about the registry key HKEY_LOCAL_MACHINE\SOFTWARE\Classes\CLSID{00024500-0000-0000-C000-000000000046} (again, where he CLSID is the same)?

Ditto for HKEY_LOCAL_MACHINE\SOFTWARE\Classes\Excel.Application -- does the CLSID match?

I really don't think this is a PowerShell problem.
Pamu 91 Reputation points

2020-11-25T05:45:51.637+00:00

The value for CLSID is : {00024500-0000-0000-C000-000000000046}

There's another key called Excel.Application.16
it has the same CLSID as well. Is this something to be concerned about ?

and all the keys you mentioned have the same {00024500-0000-0000-C000-000000000046} option. (in HKEY_CLASSES_ROOT\WOW6432Node, HKEY_LOCAL_MACHINE\SOFTWARE\Classes\ )
Rich Matheisen 47,901 Reputation points

2020-11-25T16:07:30.26+00:00

The registry looks okay. Has MS Office been installed on the machine for use by everyone, or just for a single user? If it's just for a single user are you running the script as that user?

If you double-click on an Excel file does it open the Excel spreadsheet application?

Also, are you trying to run the script on a workstation or a server?
Pamu 91 Reputation points

2020-11-26T22:17:49.367+00:00

First of all .. thanks for helping me out here ...really appreciate it !

Yes, office is installed for everyone...signed in with the user who is running this script. Apparently the powershell script worked fine before. It stopped working suddenly (or he thinks) after he did an online repair to office apps. Then as powershell stopped working, he uninstalled and reinstalled office apps once more. but still the problem continues

Yes..normal Excel files work fine.

It's a workstation...a laptop.
Rich Matheisen 47,901 Reputation points

2020-11-26T22:38:43.877+00:00

Well, if the script works fine on another machine then I'd follow the advice given to you by IanXue-MSFT and try to register the Microsoft.Office.Interop.Excel.dll manually.

Here's the link he gave to follow: regasm-exe-assembly-registration-tool

Answer 3

IT Magician 1

I am also having this issue on fully patched Windows 10 machines. I have a new thread here: https://learn.microsoft.com/en-us/answers/questions/677642/powershell-fails-to-launch-excel-with-clsid-com-er.html

Share via

Error when running a powershell script

3 answers

Your answer