How to open office excel file in the mode...

rated by 0 users
This post has 2 Replies | 1 Follower

Not Ranked
Posts 2
tererecool Posted: 02-03-2012 10:19 AM

office excel template .xlt

-> double click = document openned (title of document="template")

-> right click, select Open = document openned (title of document="template.xlt")

 

If I double click a office excel template the title of the document has the file name without the file extension, if I right click the file and select "Open" the title of the document has the file name with the file extension included. This means that something happens in the background, something is different. The question is what?

When I open the file with powershell the first presented case happens, but I need the second case to happen.

Any ideas?

Not Ranked
Posts 2

Answer found:

$missing = [System.Reflection.Missing]::Value

$variableName.workbooks.open($file.fullname, $missing, $missing, $missing, $missing, $missing, $missing, $missing, $missing, $true, $missing, $missing, $missing, $missing, $missing)

Top 10 Contributor
Posts 555
Microsoft MVP
Top Contributor

cool

Page 1 of 1 (3 items) | RSS
Concentrated Tech NSoftware Dell Compellent Sponsored by Idera and Concentrated Tech and NSoftware and Dell Compellent
Copyright 2011 PowerShell.com. All rights reserved.