Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

encrypted files

Hello everybody,

I am looking for a possibility to put external files encrypted in a folder. The files can be csv or excel. The goal is that my customer can only view the QlikView file and only QlikView can access the external encrypted files when running the script. The customer should only be able to start with the data from QlikView.

Thank you for your input!
1 Reply
Anil_Babu_Samineni

I am not sure, I understand your requirement. May be eloberate more

OR

You are expecting this, This macro do will get protectedexcel and then those moved to the un protect then it will store our path

Dim objExcel

Set objExcel = CreateObject("Excel.Application")

objExcel.Application.DisplayAlerts = false

objExcel.Application.Visible = true

objExcel.Application.Workbooks.Open "D:\ProtectExcel.xls", "3", true, , "a"

objExcel.Application.ActiveWorkbook.Unprotect

objExcel.Application.ActiveWorkbook.SaveAs "D:\UnProtectExcel.xls", , ""

objExcel.Application.DisplayAlerts = true

objExcel.Application.Quit

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful