Please post your codes, and other will help you.
but a little explain that macros will get error in saving book or naming
sheets if the name is currently used by other book/sheet.
Like:
Sub Save()
dim thename
thename = "MyFile"
Workbook.saveas "C:/" & thename & ".xls"
End sub

You can change "MyFile" to name with other string...

--

Regards,

Halim