Password secured excel - (no macro solution) ?

[lidiavonkrond]

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

[sarvesh]

Hi..Lidia,

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

How to Load password protected excel file

Regard's

Sarvesh Srivastava

[avinashelite]

check this

load a Password protected Excel File to QlikView

[lidiavonkrond]

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

[lidiavonkrond]

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

[vinieme12]

have you read Steve's reply using ODBC?

load a Password protected Excel File to QlikView

[lidiavonkrond]

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

[avinashelite]

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

[lidiavonkrond]

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

[avinashelite]

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