Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi..Lidia,
Please refer below mentioned link..hope it will help !!
How to Load password protected excel file
Regard's
Sarvesh Srivastava
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
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
have you read Steve's reply using ODBC?
load a Password protected Excel File to QlikView
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
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
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
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