<\/div>\n
Believe it or not, at this point we\u2019re almost done. In fact, to tile our workbooks horizontally all we have to do is run the following line of code:<\/p>\n
[void] $objExcel.Windows.Arrange($xlArrangeStyleHorizontal)\n<\/pre>\nAll we\u2019re doing here is calling the Arrange<\/b> method (a method that belongs to Excel\u2019s Windows collection object). As you can see, we pass the Arrange method a single parameter: $xlArrangeStyleHorizontal, the variable which \u2013 as we noted earlier \u2013 tells the script that we want to arrange the windows horizontally. That\u2019s all we have to do.<\/p>\n
Oh, good question: why did<\/i> we preface this command with [void]<\/b>? Well, when we call the Arrange method the value True<\/i> gets echoed back to the PowerShell console. That\u2019s not a big deal but, then again, it\u2019s easy enough to prevent that message from appearing onscreen. And how do we suppress a message like this? You got it: we just preface the command with [void].<\/p>\n
By the way, our running instance of Excel is going to look like a lot like this, with the three workbooks tiled on top of each other:<\/p>\n
![\"Microsoft](\"http:\/\/img.microsoft.com\/library\/media\/1033\/technet\/images\/scriptcenter\/qanda\/exceltiles.jpg\")
<\/p>\n
Pretty cool, huh?<\/p>\n
We should probably note that this works because we used a single instance of Excel to create all three of our workbooks. If you\u2019d prefer to have each workbook open in its own window (independent of all the other workbooks) then you need to use a separate instance of Excel for each workbook. In other words, you need to use a script like this:<\/p>\n
$objExcel = New-Object -com Excel.Application\n$objExcel.Visible = $True\n$objWorkbook1 = $objExcel.Workbooks.Add()\n\n$objExcel2 = New-Object -com Excel.Application\n$objExcel2.Visible = $True\n$objWorkbook2 = $objExcel2.Workbooks.Add()\n\n$objExcel3 = New-Object -com Excel.Application\n$objExcel3.Visible = $True\n$objWorkbook3 = $objExcel3.Workbooks.Add()\n<\/pre>\nAnd don\u2019t worry, VBScripters: we didn\u2019t forget you. Here\u2019s a VBScript version of our original script, the one that creates three workbooks and then arranges the three horizontally:<\/p>\n
Const xlArrangeStyleHorizontal = -4128\n\nSet objExcel = CreateObject(\"Excel.Application\")\nobjExcel.Visible = True\n\nSet objWorkbook1 = objExcel.Workbooks.Add()\nSet objWorkbook2 = objExcel.Workbooks.Add()\nSet objWorkbook3 = objExcel.Workbooks.Add()\n\nobjExcel.Windows.Arrange(xlArrangeStyleHorizontal)\n<\/pre>\nThat should do it, RE. So is the Scripting Guy who writes this column glad to be back to work after a three-day break? Let\u2019s put it this way: he did<\/i> spend the morning busily working on a script, but it was a script that reports back the number of days between the current date and July 4th<\/sup>, the next official Microsoft day off:<\/p>\ndtmEndingDate = Date\nintDays = DateDiff(\"d\", dtmEndingDate, #7\/4\/2008#)\nWscript.Echo intDays\n<\/pre>\nWow, 38 days to go. Oh well, we\u2019ll see you all tomorrow. And the day after that. And the day after that. And \u2026.<\/p>\n","protected":false},"excerpt":{"rendered":"
Hey, Scripting Guy! I have a Windows PowerShell script that starts Excel and loads three comma-separated values files into separate workbooks. What I was wondering is whether there\u2019s a way to have PowerShell tile these workbooks, either vertically or horizontally. I poked through various properties and searched the Web for ideas, but I couldn\u2019t find […]<\/p>\n","protected":false},"author":595,"featured_media":87096,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[1],"tags":[48,49,3,45],"class_list":["post-55483","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-scripting","tag-microsoft-excel","tag-office","tag-scripting-guy","tag-windows-powershell"],"acf":[],"blog_post_summary":"
Hey, Scripting Guy! I have a Windows PowerShell script that starts Excel and loads three comma-separated values files into separate workbooks. What I was wondering is whether there\u2019s a way to have PowerShell tile these workbooks, either vertically or horizontally. I poked through various properties and searched the Web for ideas, but I couldn\u2019t find […]<\/p>\n","_links":{"self":[{"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/posts\/55483","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/users\/595"}],"replies":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/comments?post=55483"}],"version-history":[{"count":0,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/posts\/55483\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/media\/87096"}],"wp:attachment":[{"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/media?parent=55483"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/categories?post=55483"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/tags?post=55483"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
![\"Hey,](\"https:\/\/devblogs.microsoft.com\/wp-content\/uploads\/sites\/29\/2019\/02\/q-for-powertip.jpg\" "\\"Hey,")
<\/p>\n![\"Spacer\"](\"https:\/\/devblogs.microsoft.com\/scripting\/wp-content\/uploads\/sites\/29\/2019\/05\/spacer.gif\")
![\"Hey,](\"https:\/\/devblogs.microsoft.com\/wp-content\/uploads\/sites\/29\/2019\/02\/a-for-powertip.jpg\" "\\"Hey,")
![\"Script](\"http:\/\/img.microsoft.com\/library\/media\/1033\/technet\/images\/scriptcenter\/ad.jpg\" "\\"Script")
<\/a> <\/p>\n