vba code to save a template as the name of a cell

Hi guys,

I am totally new to writing code and dont have much of a clue!! Tryiing to put bits and pieces together using books.

I have a list of 4000 reference numbers and for each of these I want to create a seperate workbook with the name of the referenc number. However, having a template setting. The current code that i have done, saves the existing file so it has existing information on it whiCh I dont want. To, sum up....I wnt excel to loop through my list creating a new file named with each of the refernce numbers stored in a directory of my prference...

Sounds confusing....I know..

Hope somebody can help....this is what I have so far:

Please Login or Register  to view this content.