Variable, inputfields and vbscript

Thu, 31 Aug 2017 08:32:39 GMT

Goodmorning everyone,

I did a macro that reads some imputfields, reload the data and exports some excel objects.

The variable containing the date i will pass to the selections gives me some trouble. If the variable "today" is derived from an inputfield the variable is empty ...

Here is the script:

Sub Esporta

path = ActiveDocument.Evaluate("pathXLS")

' oggi = Year(Date) & Month(Date) & Day(Date)

oggi = ActiveDocument.Evaluate("oggi")

R1 = path & oggi & "_Riepilogo1.xls"

R2 = path & oggi & "_Riepilogo2.xls"

R3 = path & oggi & "_Riepilogo3.xls"

Set C1 = ActiveDocument.GetSheetObject("CH50")

Set C2 = ActiveDocument.GetSheetObject("CH51")

Set C3 = ActiveDocument.GetSheetObject("CH53")

ActiveDocument.Reload

C1.ExportBiff(R1)

C2.ExportBiff(R2)

C3.ExportBiff(R3)

End Sub

Thanks in advance for your reply

topic Variable, inputfields and vbscript in QlikView

Variable, inputfields and vbscript