hello
iam using it with new module to add new sheet with speicfic name
its ok but the vba code not run on the new added sheet so the table doesnot change
i have problem here
can u help me ?
there are a description in the workbook i attached
and the file and the description and comments exists in this workbook on this link

Hi

There are various ways to add code to the Workbook

Programmatically add macro to Excel Workbook using VBA

Add Macro to Workbook programatically using Excel VBA

The second one might be close to you

Cheers
Shasur

__________________
C# Code Snippets (http://www.dotnetdud.blogspot.com)

VBA Tips & Tricks (http://www.vbadud.blogspot.com)