OK first I am guessing you are using Excel 2007/2010 so I recommend turning on the developer section of the ribbon. You can do so by going into Excel Options and click "Show Developer tab in the Ribbon".
Once you do this you can go to the developer tab, click Macros then click in macro name, then click new and paste the code.... if you tell me the data layout you want in the name I can write it more specifically. Make sure the folder already exists.... paste the code. I made slight changes to make it less prone to errors.
Keep in mind, excel can not create folders so the path must already exist. Alse the _ just wraps the code to the next line so it looks right and you don't need to scroll to read code.
ActiveWorkbook.SaveAs Filename:="C:\" & Range("B2") & "\" & Range("B1") _
& ".xlsm", FileFormat:=52, CreateBackup:=False
You can then run said macro directly from the same developer tab. Also you can do anything you wish to the file name. You could add say & Format(Date,"yy") & in the middle to add the 2 digit year or "yyyy" for the 4 digit... if you you wanted it laid out like you said you could do...
"ABCD1234" & Format(Date, "yyyy mm dd") & "WXYZ" & ".xlsm"
This would result in "ABCD12342012 02 24WXYZ.xlsm". Just mess around with the range and other thing. If ABCD1234 was in A1 then replace that with Range("A1").