Powershell | Com-object Excel | opens outlook?

Question

PROBLEM ONLY APPEARS WHEN NO MAIL ACCOUNT IS CONFIGURED - STILL I WOULD APPRECIATE A SOLUTION

I need some help. I have found a very weird habit of this little Script. And I have absolutely no clue, why this should happen. If I run through the code posted below, Microsoft Outlook starts. And as long as I don't terminate the Outlook process the script is stuck! Why would this code, ever, start Outlook? I am lost!

$Path     = "C:\test.xls"
#Excelvar:
$Row                 = [int] 2
$Excel               = New-Object -ComObject Excel.Application
$Excel.Visible       = $true
$Excel.DisplayAlerts = $false
        #Sheets:
        $ADUsers     = "Active Directory Users"
        $Groups      = "Create Groups"
        $UsertoGroup = "User to groups"
        $DNS         = "DNS"
#$Worksheet = $Workbook.Sheets.Add()
$checkxls = test-path -pathtype Any $Path
if ($checkxls -eq $false) {  
    $wb = $Excel.Workbooks.Add()

         $wb.Worksheets.add()

$wb.SaveAs($Path)
    $wb.Close()
    $Excel.Quit()

Thx in advance!

Powershell output after Outlook is terminated:

Application                       : Microsoft.Office.Interop.Excel.ApplicationClass
Creator                           : 1480803660
Parent                            : System.__ComObject
CodeName                          : 
_CodeName                         : 
Index                             : 1
Name                              : Tabelle4
Next                              : System.__ComObject
OnDoubleClick                     : 
OnSheetActivate                   : 
OnSheetDeactivate                 : 
PageSetup                         : System.__ComObject
Previous                          : 
ProtectContents                   : False
ProtectDrawingObjects             : False
ProtectionMode                    : False
ProtectScenarios                  : False
Visible                           : -1
Shapes                            : System.__ComObject
TransitionExpEval                 : False
AutoFilterMode                    : False
EnableCalculation                 : True
Cells                             : System.__ComObject
CircularReference                 : 
Columns                           : System.__ComObject
ConsolidationFunction             : -4157
ConsolidationOptions              : {False, False, False}
ConsolidationSources              : 
DisplayAutomaticPageBreaks        : False
EnableAutoFilter                  : False
EnableSelection                   : 0
EnableOutlining                   : False
EnablePivotTable                  : False
FilterMode                        : False
Names                             : System.__ComObject
OnCalculate                       : 
OnData                            : 
OnEntry                           : 
Outline                           : System.__ComObject
Rows                              : System.__ComObject
ScrollArea                        : 
StandardHeight                    : 15
StandardWidth                     : 10,71
TransitionFormEntry               : False
Type                              : -4167
UsedRange                         : System.__ComObject
HPageBreaks                       : System.__ComObject
VPageBreaks                       : System.__ComObject
QueryTables                       : System.__ComObject
DisplayPageBreaks                 : False
Comments                          : System.__ComObject
Hyperlinks                        : System.__ComObject
_DisplayRightToLeft               : False
AutoFilter                        : 
DisplayRightToLeft                : False
Scripts                           : System.__ComObject
Tab                               : System.__ComObject
MailEnvelope                      : 
CustomProperties                  : System.__ComObject
SmartTags                         : System.__ComObject
Protection                        : System.__ComObject
ListObjects                       : System.__ComObject
EnableFormatConditionsCalculation : True
Sort                              : System.__ComObject
PrintedCommentPages               : 0

I've experienced the same behavior. I've reported it as a bug. — Jesse Good
– Jesse Good, Commented Mar 27, 2014 at 3:50

Chris Barber · Accepted Answer · 2015-04-23 16:04:34Z

6

The issue here is that when you run $wb.Worksheets.add() it returns the new worksheet to the pipeline (this is why the Sheet properties are displayed when you kill Outlook).

I believe the MailEnvelope property of the Worksheet is what causes Outlook to open (if you store the Sheet and return the MailEnvelope property, the same behaviour occurs).

To get around this you can store the returned sheet, use the Out-Null cmdlet or cast the worksheet to void: $ws = $wb.Worksheets.add() or $wb.Worksheets.add() | Out-Null or [void] $wb.Worksheets.add()

edited Apr 23, 2015 at 16:04

answered Apr 23, 2015 at 15:54

Chris Barber

5134 silver badges10 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

mjolinor · Accepted Answer · 2013-10-31 11:30:48Z

0

You might try running Excel in "safe mode":

http://social.msdn.microsoft.com/Forums/vstudio/en-US/79a8d280-3b80-4371-95e1-e7827472d36f/how-to-start-excel-in-safe-mode-programmatically?forum=vsto

answered Oct 31, 2013 at 11:30

mjolinor

68.7k7 gold badges118 silver badges141 bronze badges

3 Comments

XXInvidiaXX Over a year ago

thx for the idea, but how can I translate that into powershell?

XXInvidiaXX Over a year ago

couldn't figure out how to do that in powershell. Could you give me a code example of running Excel in "safe mode" in powershell?

mjolinor Over a year ago

Nope. If it's not helping, I'll delete the answer.

Collectives™ on Stack Overflow

Powershell | Com-object Excel | opens outlook?

2 Answers 2

Comments

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related