Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
LINKEDIN LIVE: Democratizing data to enhance customer-centricity. JULY 29TH REGISTER TODAY
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