topic how to add more than 7 excel sheet Using macro in QlikView

how to add more than 7 excel sheet Using macro

Anonymous — Tue, 12 Aug 2014 12:35:48 GMT

Hi,

I'm trying to add more than 7 excel sheet using macro.But it showing this error msg "Subscript out of range".

kindly help me.How to resolve this issue.

Tue, 12 Aug 2014 12:47:34 GMT

Do you mean to load the excel files?

If it is so, you could try this:

LOAD [Tabla MIC],

FROM

[<your path>\*.xls]

(biff, embedded labels, table is [Sheet 1$]);

With that you can load all the excel files on a path without macros.

Anonymous — Tue, 12 Aug 2014 12:57:09 GMT

No,

export to excel using macro.

ecolomer — Tue, 12 Aug 2014 13:16:18 GMT

The button are active and send two tables in two excel pages in the same file

ecolomer — Tue, 12 Aug 2014 13:19:18 GMT

Sorry is another file

Anonymous — Tue, 12 Aug 2014 13:27:19 GMT

Hi,

i can able to generate two excel sheet.but i can't able to generate more than seven excel sheet.

ecolomer — Tue, 12 Aug 2014 13:35:25 GMT

if you go to the editor as see in the image, you can personalize your problem

Anonymous — Tue, 12 Aug 2014 13:46:05 GMT

No.

please understand my query.i cannot able to generate more than seven sheet.

Tue, 12 Aug 2014 13:57:12 GMT

Did you try changing the Array size

ecolomer — Tue, 12 Aug 2014 14:16:43 GMT

You need change options in excel to open 10 o more sheet when a new file is created

See the figures

And in the editor personalize your problem with your tables ...

Anonymous — Wed, 13 Aug 2014 05:04:46 GMT

Thank you very much.