Hi guys,

It seems to be possible to open a password protected Excel file but somehow I'm not getting the correct results. Excel opens the workbook just fine but it keeps asking for a password. It should be auto entered by the open line. See: this link, this link and this link.
Am I missing something? Is this not possible in kix? Am I just dumb and blind when it comes to COM stuff?

BTW: this is about the "Open file" password not the "Edit file" password.

Break on

$objExcel = CreateObject("Excel.Application")

$objWorkBook = $objExcel.Workbooks.open("d:\somefolder\book1.xlsx",Password:="Test123")

$objexcel.Visible = True

- Chuck Norris once sold ebay to ebay on ebay.