Create worksheets from a list using excel VBA

May 17, 2012 at 14:57:25
Specs: Windows XP
DerbyDad03 - I loved the vba code that you provided another user, and I've been trying to get it to work for my application as well. I am an amatuer with excel and trying my darndest to learn more and more about it. The code you provided is here :

I couple of questions I have is how do I accomplish the same thing without the TOC?

Also, I am using dates to name the tabs. With the code you provided, it returns an error. What needs to be changed in the code to rename the tabs using dates?

See More: Create worksheets from a list using excel VBA

Report •

May 17, 2012 at 19:57:50
If your Dates have / (slashes) they will not work because Sheet names cannot contain slashes.

You have to use something like MONTH(A1) & "-" & DAY(A1) & "-" & YEAR(A1) to create a date like 5-17-2012.

re: "how do I accomplish the same thing without the TOC?"

Well, since the code in that thread creates a TOC, you obviously don't want the "same thing".

What do you want?

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •

May 23, 2012 at 16:01:13
The autocreate and rename macro is awesome. I am trying to create additional worksheets from the master I have, and the vba code you provided to another user works great. I have no need for a TOC and I've tried to play with the VBA code to remove what I thought was the TOC worksheet/code and have not been successful. I have two(2) seperate worksheets that I am trying to accomplish the autocreate and rename from a list. The first workbook that i need to create additional worksheets in uses a list of my employees. The second workbook I am building/using uses weekend ending dates, and I am trying to autocreate and rename the worksheets/tabs with the date as the name of the tab. I have no need for a TOC, in either workbook, so anything you can do to assist would be greatly appreciated. I hope this answers your previous question.

Report •

Related Solutions

Ask Question