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