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.
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.
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
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
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
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