Create Multiple New Excel Files From Excel List

[JADownie]

Hello -

I have a file which lists out 305 unique client ids starting in Row 1. For each of these ids, I need to create a new excel workbook with and save it to a location with the name of the id value in column A. I really don't want to have to manually create 305 files now, so I was hoping maybe someone had a macro or shortcut that they could suggest for me here? I just want to save each new file to My Documents now - C:\Documents and Settings\AA.BB\My Documents\Final Files

Thanks in advance for any helps and tips here today!

 

[Jubjab]

try

Sub a()

For i = 1 To 305

ActiveWorkbook.SaveAs Filename:="C:\Documents and Settings\AA.BB\My Documents\Final Files\" & Range("a" & i).Value

Next i

End Sub