topic Re: Password secured excel - (no macro solution) ? in QlikView

Password secured excel - (no macro solution) ?

lidiavonkrond — Mon, 03 Apr 2017 12:10:32 GMT

Hi All,

Does anyone knows if there is a workaround or solution to open a password secured excel file.

The company secures excel files stored on SharePoint.

There is ETL structure - those excels are set to qvd in Extraction layer, by ODBC connection to SharePoint ( also secured by windows)

On QV production it is not allowed to open excels or any other file before connecting

QV macro solutions are not allowed also.

Thanks in advance.

Lidia

Re: Password secured excel - (no macro solution) ?

sarvesh — Mon, 03 Apr 2017 12:16:33 GMT

Hi..Lidia,

Please refer below mentioned link..hope it will help !!

How to Load password protected excel file

Regard's

Sarvesh Srivastava

Re: Password secured excel - (no macro solution) ?

avinashelite — Mon, 03 Apr 2017 12:32:47 GMT

check this

load a Password protected Excel File to QlikView

Re: Password secured excel - (no macro solution) ?

lidiavonkrond — Mon, 03 Apr 2017 12:43:55 GMT

Hi Sarvesh,

tnx for reply

But the thing is that as well macro's as opening files not being allowed.

I'm looking for an other solution.

Lidia

Re: Password secured excel - (no macro solution) ?

lidiavonkrond — Mon, 03 Apr 2017 12:45:34 GMT

Hi Avinash,

tnx for reply

Already red the post before asking-

The point is that as well macro's as opening files not being allowed.

I'm looking for an other solution.

Lidia

Re: Password secured excel - (no macro solution) ?

vinieme12 — Mon, 03 Apr 2017 13:11:17 GMT

have you read Steve's reply using ODBC?

load a Password protected Excel File to QlikView

Re: Password secured excel - (no macro solution) ?

lidiavonkrond — Mon, 03 Apr 2017 13:15:38 GMT

Yep i have

that one also creates marco ( vbs) that first opens the file.

both are not allowed in the deployment at the requested company

tnx

Re: Password secured excel - (no macro solution) ?

avinashelite — Mon, 03 Apr 2017 13:33:22 GMT

I think the only way to do that is save your file without a password but you can do one thing remove the password at document level and implement it at the sheet level then Qlikview will read the excel without any issues , without the macro I feel this the option we have

Re: Password secured excel - (no macro solution) ?

lidiavonkrond — Mon, 03 Apr 2017 13:42:05 GMT

Hi Avinash,

It's the answer i expected, but not hoped for.

I will propose you're solution.

An extra security level in SharePoint, is a solution that i will propose also

tnx Lidia

Re: Password secured excel - (no macro solution) ?

avinashelite — Mon, 03 Apr 2017 14:05:13 GMT

Yes , you could do that as well , host the excel in the Share point and handle the access . Give access for the QV service account that will solve the problem