Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Well you can use the OnPostReload document trigger to run the created macro.
Is that suitable in your case ?
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.
HI JP
Will the macro start all by it self if a create a task and schedule it to say 00:10?
BR
DJ
Well you can use the OnPostReload document trigger to run the created macro.
Is that suitable in your case ?
Thanks for your input. Works like a charm.
BR
DJ
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.