Exporting data into Excel then creating a pivot table?

[#1]

Hello,

I'm trying to write some VBscript to export a straight chart into Excel then inside Excel create a pivot table with this data.
I can get as far as exporting the data to Excel but when it gets to the section to create the pivot table it produces errors.

Has anyone done this before and if so would you mind sharing the code.

Regards
Mark

[fernandotoledo]

Are we allowed to talk about excel atomatization here?

just kidding!

We did something diferent in a customer, where we exported the data to an XLS, then another XLS with the Pivot Table automatically loads the data from the XLS generated by the QVW. But the XLS exported by qlikview had a fixed structure.

I don´t know much about the code, but that´s an Idea.

Hope it helps

Fernando

[#3]

Thanks for your reply Fernando.

I don't think your suggestion will help us though, our customers access the dashboard though a website so we need to generate a new excel instance.

I'm sure it must be fairly straight forwards for someone who understands VB script and excel automation. I can write Macro's in VBA inside of Excel pretty easily but it seems a whole lot trickier outside of Excel. Now I've thought about this it's not really even a Qlikview question but any help would be appreciated, to help get me out of a hole.

Mark

[#4]

I would advice to look on www.mrexcel.com there are plenty examples how to use vba to create a pivot table..

goodluck,

david