topic Re: How to export a group of text box and a chart without using a macro? in QlikView

How to export a group of text box and a chart without using a macro?

Anonymous — Fri, 21 Oct 2016 14:42:00 GMT

Hi,

I am trying to export a group of text boxes (without loosing the format) to excel. But the server where I will publish the QV report won't accept macros.

I am trying to have the right click >Export to excel functionality for all the fields at the same time.

Is this possible without a macro?

thanks in advanced.

Re: How to export a group of text box and a chart without using a macro?

wallerjc — Fri, 21 Oct 2016 14:55:12 GMT

Not realy how you're imagining.

NPrinting can solve this easily, but if you don't have that, can you build some kind of table with the values in?

Is it not acceptable to have the user export from there?

Re: How to export a group of text box and a chart without using a macro?

Aurelien_Martinez — Fri, 21 Oct 2016 15:03:15 GMT

Without macro is not possible ;(

But if you have NPrinting On-Demand you can create a template and export to Excel

Aurélien

Re: How to export a group of text box and a chart without using a macro?

Anonymous — Fri, 21 Oct 2016 15:27:26 GMT

How can I do this with a macro, I have something like this:

Set obj = ActiveDocument.GetSheetObject("CH02")
obj.SendToExcel

This only allows me to export the pivot table, what else should I add to export other text boxes with the previous table? can I set an specific column row?

Re: How to export a group of text box and a chart without using a macro?

Anonymous — Fri, 21 Oct 2016 15:42:34 GMT

Is it not acceptable for the application to do it? or QV won't accept use that?.

I have created a kind of template with text boxes, so I cannot put them in a table.

I couldn't use NPrinting neither.

Re: How to export a group of text box and a chart without using a macro?

mayankraoka — Fri, 21 Oct 2016 21:23:12 GMT

You can use reporting tab on top and create it as per your need..

On Oct 21, 2016 9:12 PM, "Roberto Cespedes" <qcwebmaster@qlikview.com>

Re: How to export a group of text box and a chart without using a macro?

marcus_sommer — Sat, 22 Oct 2016 13:24:55 GMT

Take a look here: QlikTip #32: Exporting multiple QV objects to a single Excel document.

- Marcus

Re: How to export a group of text box and a chart without using a macro?

Anonymous — Mon, 24 Oct 2016 13:46:19 GMT

Hi Marcus,

I have tried that, but I got the following error:

Type mismatch: 'copyObjectsToExcelSheet'

And QV marks this expression:

Set objExcelWorkbook = copyObjectsToExcelSheet(ActiveDocument, aryExport)

Any idea?

Re: How to export a group of text box and a chart without using a macro?

marcus_sommer — Mon, 24 Oct 2016 16:51:26 GMT

You need to take the whole code from the download-example and not only the code-snippets from the posting itself:

http://www.qlikblog.at/wp-content/uploads/2011/03/qlikblog_ExportToMultipleExcelSheets.zip

- Marcus

Re: How to export a group of text box and a chart without using a macro?

Anonymous — Mon, 24 Oct 2016 17:22:32 GMT

Still not working, I have downloaded the file, but when hit on the links it open the edit module and does not do anything.

I allowed to use the macros but the file is not working.

Re: How to export a group of text box and a chart without using a macro?

marcus_sommer — Mon, 24 Oct 2016 17:57:14 GMT

Please provide the used code and also what happens when - any error-message?

- Marcus

Re: How to export a group of text box and a chart without using a macro?

Anonymous — Mon, 24 Oct 2016 18:02:35 GMT

I just downloaded the file that you posted and tried to run it.

Re: How to export a group of text box and a chart without using a macro?

marcus_sommer — Mon, 24 Oct 2016 18:12:05 GMT

Had you adjusted the file-path and name and also the ID's from the sheets and objects and another to customizing things?

- Marcus

Re: How to export a group of text box and a chart without using a macro?

Anonymous — Mon, 24 Oct 2016 18:47:44 GMT

I didn't touch anything, I just downloaded the file to see it working, but it didn't.