encrypted files

[Anonymous]

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!

[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