encrypted files

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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!

Re: encrypted files

Anil_Babu_Samineni — Mon, 07 Nov 2016 16:41:53 GMT

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

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

topic encrypted files in QlikView

encrypted files

Re: encrypted files