VBA open protected password

Closed
helpMe - 6 Apr 2016 à 12:30
 Blocked Profile - 7 Apr 2016 à 16:23
Hi,

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 response

Blocked Profile
6 Apr 2016 à 17:05
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
7 Apr 2016 à 16:23
Contact the encryption people and see if there is an SDK /api hook then!