Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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