topic Macro using save as Sttright table to QVD in QlikView

Macro using save as Sttright table to QVD

Surya — Sat, 16 Nov 2024 02:27:22 GMT

Hello .,

sub Export

set obj1 = ActiveDocument.GetSheetObject("CH197")

obj1.ExportBiff "C:\User 4\Surya\Date.qvd"

end sub

I Reload every day my dashboard on that time the QVD save as Today's Date.,Plase help me

Thanks In Advance

Surya — Wed, 18 Sep 2019 06:18:22 GMT

sub Export
set obj1 = ActiveDocument.GetSheetObject("CH197")

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

obj1.ExportBiff "C:\User 4\Surya\"&strDate&".xlsx"

end sub