EXPORT QVD WITH VALUE OF A VARIABLE

Anonymous — Tue, 19 Apr 2011 13:18:20 GMT

Hello

I have a macro that exports a file QVD with the employee's name
.
Now I want to add the variable VR_MES the file name that returns months and years.

Employee 02 2011.QVD

sub export_Venda

set obj = ActiveDocument.GetSheetObject("CH14")
set val=ActiveDocument.Fields("Employee").GetPossibleValues
FUNCIONARIO = val.Item(i).Text
obj.ExportEx "D:\Desenv\Qvd_Planejamento_Compra\Venda_"&Employee&".qvd", 4
msgbox("Dados exportados com sucesso")

end sub

EXPORT QVD WITH VALUE OF A VARIABLE

Miguel_Angel_Baeyens — Tue, 19 Apr 2011 13:31:37 GMT

Hi,

First make sure that the variable stores the date properly, and not the numeric format of QlikView nor decimals (dates with times).

Then add in the macro the lines corresponding to the reading of the variable and the path modification:

Sub export_Venda Set obj = ActiveDocument.GetSheetObject("CH14") Set val = ActiveDocument.Fields("Employee").GetPossibleValues Set vFecha = ActiveDocument.Variables("vDateVariable") vFecha = vFecha.GetContent.String FUNCIONARIO = val.Item(i).Text obj.ExportEx "D:\Desenv\Qvd_Planejamento_Compra\Venda_"&Employee&"_"&vFecha&".qvd", 4 MsgBox("Dados exportados com sucesso") End Sub

Hope that helps.

topic EXPORT QVD WITH VALUE OF A VARIABLE in QlikView

EXPORT QVD WITH VALUE OF A VARIABLE

EXPORT QVD WITH VALUE OF A VARIABLE