Little change is require in Macro..exports Tables in excel

[pra_kale]

Hi All,

Below attached macro is running fine to export only 3 tables..but when I tried to export more than 3 tables it gives error.

I want to export around 20 tables in a single excel file where sheet names is the same as tables names. I tried at my end to make the change in a macro but unable to find the solution.

Can any one help in this.