_excelbookopen passing the password

[Dazzler]

People,

I have an excel spreadsheet (2003). It is password protected for modify. I have achieved this by Tools->Options, Security tab, putting a password in 'Password to modify'. Save the sheet.

When the sheet is re-opened, you are prompted for a password. This is ok.

The problem is with: _excelbookopen

I pass the password in the function but the prompt for password still opens. I need the sheet to open without the prompt.

$excel = _excelbookopen($full_path, 1, false, "", "password")

What am I doing wrong?

[shornw]

Just guessing here, but to start I would try (in case opening the file sees Read before Write):

$excel = _excelbookopen($full_path, 1, false, "password", "password")

What version of Excel btw

[hannes08]

$oEx = _ExcelBookOpen(@ScriptDir & "\test.xls", 1, False, "", "password2")

This works fine for me (XP SP3 + Excel 2003)

[Dazzler]

AHA!

As yours worked, something is wrong with mine. Its an .xlsx. So there is conversion going on as you open and close; and this is clearly undermining the _excelbookopen. I resaved as .xls and it works a treat.

Thank you people.

[hannes08]

Glad I could help you to find the solution, though I wouldn't have guessed this solution.