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

[Anonymous]

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.

[wallerjc]

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?

[Aurelien_Martinez]

Without macro is not possible ;(

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

Aurélien

[Anonymous]

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?

[Anonymous]

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.

[mayankraoka]

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>

[marcus_sommer]

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

- Marcus

[Anonymous]

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?

[marcus_sommer]

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

[Anonymous]

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.