Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Highlighted
Partner
Partner

Password secured excel - (no macro solution) ?

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

Tags (3)
9 Replies
sarvesh
Contributor III

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

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) ?

Partner
Partner

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


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

Partner
Partner

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

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
Esteemed Contributor II

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

have you read Steve's reply using ODBC?

load a Password protected Excel File to QlikView

Partner
Partner

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

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) ?

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

Partner
Partner

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

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) ?

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