Export to excel w/ macro

[#1]

I'm exporting one object to excel with this

sub ChartToEXCEL 

    set obj = ActiveDocument.GetSheetObject("GR") 

    obj.ExportEx "E:\QlikView\DESA\APP\TABLA2.XLS", 5

end sub 

To Sheet 1

Now i'd like to export 2 objects to the same excel, to sheet 1 and sheet 2

How can i do this?

Thanks

[Gysbert_Wassenaar · Accepted solution]

See this blog post: QlikTip #32: Exporting multiple QV objects to a single Excel document

[#3]

Thank you this is useful

but i'd like to save the excel, i mean export and save

not only export

regards

[Gysbert_Wassenaar]

And what's stopping you?

[#5]

How do i do that?

[Gysbert_Wassenaar]

Do what?

[#7]

I want to save the excel in the macro, not only export.

With this macro i am only exporting it.

[Gysbert_Wassenaar]

Then add a line to the macro code that saves the document.  Just like the blog post says:

36	'// Now either just leave Excel open or do some other stuff here

37	'// like saving the excel, some formatting stuff, ...

It's just vbscript. The internet is full of it. objExcelWorkbook.save or something like it. Have a google. Or hire a programmer if you want to be lazy.

[ElizaF]

Hi Jeremias,

See the macro code used here: Export to Excel for each dimension value as separate sheet

Also, you can find many information about macros in : Useful Qlikview Macros

Regards,

Eliza