Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP 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

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)