QlikView Data into Excel speadsheet

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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.

Re: QlikView Data into Excel speadsheet

ramasaisaksoft — Wed, 11 Jul 2018 17:25:19 GMT

Hi Carter,

The below link will help to you.

else

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