Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Now Live: Qlik Sense SaaS Simplified Authoring – Analytics Creation for Everyone: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
jayaseelan
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