Createing a QVD from a chart

[Anonymous]

Hi

I have a pivot chart that I want to store data from.

I want to store them into a QVD every night.

I found a tread that stated:

Create a macro with

Set obj=ActiveDocument.GetSheetObject(CH18)

obj.ExportEX "C:\test.qvd", 4

So I tried by ctrl+m and inserted the above code.

But get the error "Object required: 'obj'"

I have not tried macro before, so I`m way out of my comfort zone.

BR

DJ

[#2]

Hi Dan,

You just need to enclose the object ID within double quotes like this:

Set obj=ActiveDocument.GetSheetObject("CH18")

and the qvd will be created.

[Anonymous]

HI JP

Will the macro start all by it self if a create a task and schedule it to say 00:10?

BR

DJ

[#4 · Accepted solution]

Well you can use the OnPostReload document trigger to run the created macro.

Is that suitable in your case ?

[Anonymous]

Thanks for your input. Works like a charm.

BR

DJ

[dmohanty]

Hi Dan,

We have a similar requirement. It didn't work like a charm for us

Are you running the QVW with OnPostReload, manually or through Publisher/QMC?

Seems Publisher is not supporting the OnPostReload. I am able to store the Chart data into QVD, if I run the QVW manually with OnPostReload trigger, but QVD is not created when QVW is ran on QMC.

Please suggest.