QlikView Data into Excel speadsheet

[Anonymous]

I have a premade excel sheet, i need to take the values from qlikview and import them into an excel spreadsheet.

What would i need to start with and how would I begin to do this.

[ramasaisaksoft]

Hi Carter,

The below link will help to you.

Export data to an existing xls

else

common Macro to export excel for 6 different objects

Using below macro code u can create the folder in dynamically and saved the file,

vPath = Ur path folder i.e  D:\\Test\

strDate = Year(Date()) &"-"& month(date()) &"-"& Day(Date())

set vPathName = ActiveDocument.Variables("vPath")

GetVarValue = vPathName.GetContent.String

Dim filesys

Dim newfolder

set filesys=CreateObject("Scripting.FileSystemObject")

  If Not filesys.FolderExists(GetVarValue) Then

    Set newfolder = filesys.CreateFolder(GetVarValue)    

    filePath = newfolder&"\Test_"&strDate&".xlsx"

  Else

    filePath = GetVarValue&"\Test_"&strDate&".xlsx"  

  End If

objExcelDoc.SaveAs filePath