Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear All,
i am using a macro for data export to qvd after post reload.
i am writing this code
Sub DashboardExport
set obj = ActiveDocument.GetSheetObject("CH01")
obj.ExportEx "D:\SHARE\ProfitabilityOptimized.qvd", 4
end sub
But Qvd is not making this location.But when i press Contol+M And then Test then qvd make this location.But When i do reload then it is not makring,because i trigger after reload .
Kindly help me for resoliving this
In the Document Setting >Trigger >Post reload > You have given wrong macro name change it to the name as you have in the macro editor
DashboardExport
Check this app
How your triggering the macro (DashboardExport) after reload any triggers your using or using the button ?
After Reload i am using the trigger the macro
share the sample app...
Where i attach sample app because there is no option for attach
Are you testing the macro and reloading on the same server?
Maybe the reload server does not have the D drive mapped?
i have test macro on my desktop ..it is working but after reload it is not working.
remove the path from the macro and try a reload to see if it writes to the same location as the QVW?
Top Right > Use Advanced editor then to the right bottom you will find the option
Here i have attached qlikview application