WorkbookOpen() in Excel 2003 on Password Protected .xlsm file

[LJMetzger]

Hi,

I am attempting to open a password protected .xlsm file using WorkbookOpen() in Excel 2003. Even though the password is in the WorkbookOpen() command, I am prompted to enter the password.

Data Files with passwords are all set using Tools > Options > Security > Password to Open
The password for the two password protected files is ABC.

Code excerpt that compiles and runs (but asks for Password):

Please Login or Register  to view this content.

Am I doing something wrong, or is this a feature of the Microsoft .xlsm to .xls converter?

The attached .zip file contains a sample workbook and 4 sample data files:
1. OpenXlsmPasswordProtectedFileFromExcel2003.xls
2. xxx.xls
3. yyy.xlsm
4. aaaPasswordIsABC.xls
5. bbbPasswordIsABC.xlsm

Lewis

[Marc L]

Hi,

same issue : must be the converter involved …

[LJMetzger]

Thanks for the reply Marc.

I have two workarounds for the problem.

One uses SendKeys , which will probably work in XP and Vista. It may work in Windows 7, possibly requiring UAC (User Account Control) to be turned off in Windows 7, which is NOT RECOMMENDED.

The other workaround uses keybd_event() Api. I have a keybd_event() Sub that emulates a small subset of SendKeys. This works in 32 bit Vista for me. It has not been tested on other Windows Versions.

The attached .zip file contains a sample Excel file which implements the workarounds, and a .xlsm data file. Both should be placed in the same folder.

Lewis

Code follows:

Please Login or Register  to view this content.

Please Login or Register  to view this content.