Skip to main content
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
Showing results for 
Search instead for 
Did you mean: 
Creator III
Creator III

Macros to ask users for path to save excel on their machine need for server or access point

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

0 Replies