5 Replies Latest reply: Sep 23, 2016 9:00 AM by Matheus Colares RSS

    Macro .csv

    Matheus Colares

      Hi folks.

      Recently i open a discussion about macro to export to excel in qlikview server, and  we come to conclusion that is not possible if excel is not instaled in server...so i keep trying the others ways and i got this:

      Sub ExportToCSV

                Set objFSO = CreateObject("Scripting.FileSystemObject")

                Set t2 = ActiveDocument.GetSheetObject("CH58")

                t2.Export "\\10.234.239.156\WeCanDoThat\teste.csv", ";", , TRUE

                Set objTextFile = objFSO.OpenTextFile ("\\10.234.239.156\WeCanDoThat\teste.csv", 8, True)               

                objTextFile.WriteLine("")          

                objTextFile.Close

                Set t2 = ActiveDocument.GetSheetObject("CH59")

                t2.Export "\\10.234.239.156\WeCanDoThat\teste.csv", ";", , TRUE

                Set objTextFile = objFSO.OpenTextFile ("\\10.234.239.156\WeCanDoThat\teste.csv", 8, True)               

                objTextFile.WriteLine("")          

                objTextFile.Close

                Set t2 = ActiveDocument.GetSheetObject("CH60")

                t2.Export "\\10.234.239.156\WeCanDoThat\teste.csv", ";", , TRUE

      End Sub

      I export to .csv, in server it works, it create and save the file...but in qlikview web, nothing happening...

      I read some text about this, and saw something about ajax client, and ie plugin, but i dont undestand very well...

      Anyone know what i do wrong....or it is not possible and i have to give up....XD

      note: i allow all macro options in qliview.

       

      Thanks!!!