create new excel tab using vb

[lleemon]

Currently I have an application that puts data into a excel file in select locations each month. I manually have to go to excel and create a new tab in my file and then change some code to put data in the right tab.

Does anyone know how I can do this with code so I don't have to manually do this process?

Thanks for any help.

[Static]

you mean add sheets?

in excel:
worksheets.add
activesheet.name = "???"


in vb..just add the excel object name infront!


good tip...Can't figure it out? create a macro and view the code! good stuff in there!