Hi experts,
I am using below syntax for "Macros to ask users for path to save excel on their machine".
This working fine in qlikview desktop.
The issue is not working in qlikview server.
anyone can please help on this.
Sub exportcsv
Set Req_Obj = ActiveDocument.GetSheetObject("TB01")
Set objShell = CreateObject("Shell.Application")
Set objFolder = objShell.BrowseForFolder(0, "Select the path to save the csv:", 1, "Computer")
On Error Resume Next
If objFolder Is Nothing Then
Set objShell = nothing
Set objFolder = nothing
Exit sub
End If
FileName = "Exoported Csv File.csv"
Req_Obj.Export objFolder.self.path & "\" & FileName , ", "
end sub