EXPORT TO QVD

[panipat1990]

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

[avinashelite]

How your triggering the macro (DashboardExport) after reload any triggers your using or using the button ?

[panipat1990]

After Reload i am using the trigger the macro

[avinashelite]

share the sample app...

[panipat1990]

Where i attach sample app because there is no option for attach

[Anonymous]

Are you testing the macro and reloading on the same server?

Maybe the reload server does not have the D drive mapped?

[panipat1990]

i have test macro on my desktop ..it is working but after reload it is not working.

[Anonymous]

remove the path from the macro and try a reload to see if it writes to the same location as the QVW?

[avinashelite]

Top Right > Use Advanced editor then to the right bottom you will find the option

[panipat1990]

Here i have attached qlikview application