VBA open protected password

helpMe - Apr 6, 2016 at 12:30 PM
 Blocked Profile - Apr 7, 2016 at 04:23 PM

I am using the code below to open a file

Set wb = excelApp.Workbooks.Open(strFilePath, , , , "myPassword")

I get the error

Error 1004, This workbook has been password protected with an XOR encryption scheme and cannot be shared in this region. To enable sharing, please change the encryption scheme.

Can t find any help on Internet

1 reply

Blocked Profile
Apr 6, 2016 at 05:05 PM
File is encrypted. Are you running bitlocker on the native machine?
Why is that so important? The file is from external source. I can open the file typing the password , however I cant through VBA.
But if you need to know I work on full disk encryption.
Blocked Profile
Apr 7, 2016 at 04:23 PM
Contact the encryption people and see if there is an SDK /api hook then!