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 · Accepted solution]

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

[rahulpawarb]

I agree with Avinash! Rename the macro name from Export To Qvd to DashboardExport. This will solve your problem.

Regards!

Rahul

[sasiparupudi1]

Change the MacroName from  Export To Qvd to ExportToQvd

And in the code window use the subroutine name as ExportToQvd

Sub ExportToQvd

set obj = ActiveDocument.GetSheetObject("CH01")

obj.ExportEx "D:\SHARE\ProfitabilityOptimized.qvd", 4

End Sub

hth

Sasi