Previous Topic Next Topic

VBA open protected password

Closed
helpMe - Apr 6, 2016 at 12:30 PM
 Blocked Profile - Apr 7, 2016 at 04:23 PM
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 reply

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