topic Re: Export to excel w/ macro in QlikView

Export to excel w/ macro

Thu, 22 Oct 2015 15:41:11 GMT

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

Re: Export to excel w/ macro

Gysbert_Wassenaar — Thu, 22 Oct 2015 15:45:12 GMT

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

Re: Export to excel w/ macro

Thu, 22 Oct 2015 16:05:45 GMT

Thank you this is useful

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

not only export

regards

Re: Export to excel w/ macro

Gysbert_Wassenaar — Thu, 22 Oct 2015 16:19:04 GMT

And what's stopping you?

Re: Export to excel w/ macro

Thu, 22 Oct 2015 17:15:11 GMT

How do i do that?

Re: Export to excel w/ macro

Gysbert_Wassenaar — Thu, 22 Oct 2015 17:24:45 GMT

Do what?

Re: Export to excel w/ macro

Thu, 22 Oct 2015 17:28:48 GMT

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

With this macro i am only exporting it.

Re: Export to excel w/ macro

Gysbert_Wassenaar — Thu, 22 Oct 2015 17:48:16 GMT

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.

Re: Export to excel w/ macro

ElizaF — Thu, 22 Oct 2015 19:49:37 GMT

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