how to add more than 7 excel sheet Using macro

[Anonymous]

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.

[#2]

Do you mean to load the excel files?

If it is so, you could try this:

LOAD [Tabla MIC],

     <your fields>

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]

No,

export to excel using macro.

[ecolomer]

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

[ecolomer]

Sorry is another file

[Anonymous]

Hi,

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

[ecolomer]

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

[Anonymous]

No.

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

[#9]

Did you try changing the Array size

[ecolomer]

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 ...