Errors on Server 2012, Office 2013

Jul 18, 2014 at 4:49 PM
I'm in en-us. Any tips?

Add-Type : Could not load file or assembly 'Microsoft.Office.Interop.Excel, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c' or one of
its dependencies. The system cannot find the file specified.
At C:\Users\administrator.RUSSLAB\Documents\WindowsPowerShell\Modules\SqlServerInventory\SqlServerInventory.psm1:4544 char:3
  • Add-Type -AssemblyName Microsoft.Office.Interop.Excel
  • ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    • CategoryInfo : NotSpecified: (:) [Add-Type], FileNotFoundException
    • FullyQualifiedErrorId : System.IO.FileNotFoundException,Microsoft.PowerShell.Commands.AddTypeCommand
Exception setting "Title": "The property 'Title' cannot be found on this object. Verify that the property exists and can be set."
At C:\Users\administrator.RUSSLAB\Documents\WindowsPowerShell\Modules\SqlServerInventory\SqlServerInventory.psm1:4658 char:3
  • $Workbook.Title = 'SQL Server Inventory - Database Engine'
  • ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    • CategoryInfo : NotSpecified: (:) [], SetValueInvocationException
    • FullyQualifiedErrorId : ExceptionWhenSetting
Method invocation failed because [System.__ComObject] does not contain a method named 'Item'.
At C:\Users\administrator.RUSSLAB\Documents\WindowsPowerShell\Modules\SqlServerInventory\SqlServerInventory.psm1:4681 char:3
  • $Excel.Worksheets.Add($MissingType, $Excel.Worksheets.Item($Excel.Worksheets.C ...
  • ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    • CategoryInfo : InvalidOperation: (Item:String) [], RuntimeException
    • FullyQualifiedErrorId : MethodNotFound
The property 'DisplayAlerts' cannot be found on this object. Verify that the property exists and can be set.
At C:\Users\administrator.RUSSLAB\Documents\WindowsPowerShell\Modules\SqlServerInventory\SqlServerInventory.psm1:10443 char:4
  • $Worksheet.Application.DisplayAlerts = $false
  • ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    • CategoryInfo : InvalidOperation: (:) [], RuntimeException
    • FullyQualifiedErrorId : PropertyNotFound
Method invocation failed because [System.__ComObject] does not contain a method named 'SaveAs'.
At C:\Users\administrator.RUSSLAB\Documents\WindowsPowerShell\Modules\SqlServerInventory\SqlServerInventory.psm1:10444 char:4
  • $Workbook.SaveAs($Path)
  • ~~~~~~~~~~~~~~~~~~~~~~~
    • CategoryInfo : InvalidOperation: (:) [], RuntimeException
    • FullyQualifiedErrorId : MethodNotFound
The property 'Saved' cannot be found on this object. Verify that the property exists and can be set.
At C:\Users\administrator.RUSSLAB\Documents\WindowsPowerShell\Modules\SqlServerInventory\SqlServerInventory.psm1:10445 char:4
  • $Workbook.Saved = $true
  • ~~~~~~~~~~~~~~~~~~~~~~~
    • CategoryInfo : InvalidOperation: (:) [], RuntimeException
    • FullyQualifiedErrorId : PropertyAssignmentException
Exception setting "ScreenUpdating": "Exception from HRESULT: 0x800AC472"
At C:\Users\administrator.RUSSLAB\Documents\WindowsPowerShell\Modules\SqlServerInventory\SqlServerInventory.psm1:10448 char:4
  • $Excel.ScreenUpdating = $true
  • ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    • CategoryInfo : NotSpecified: (:) [], SetValueInvocationException
    • FullyQualifiedErrorId : ExceptionWhenSetting
Exception calling "Quit" with "0" argument(s): "Exception from HRESULT: 0x800AC472"
At C:\Users\administrator.RUSSLAB\Documents\WindowsPowerShell\Modules\SqlServerInventory\SqlServerInventory.psm1:10453 char:4
  • $Excel.Quit()
  • ~~~~~~~~~~~~~
    • CategoryInfo : NotSpecified: (:) [], MethodInvocationException
    • FullyQualifiedErrorId : COMException
Method invocation failed because [System.__ComObject] does not contain a method named 'Item'.
At C:\Users\administrator.RUSSLAB\Documents\WindowsPowerShell\Modules\SqlServerInventory\SqlServerInventory.psm1:4691 char:4
  • $Worksheet = $Excel.Worksheets.Item($WorksheetNumber)
  • ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    • CategoryInfo : InvalidOperation: (Item:String) [], ParentContainsErrorRecordException
    • FullyQualifiedErrorId : MethodNotFound