this is just a guess:
Activeworkbook.SaveAs "C:\Mybook", fileformat:=xlNormal

note the colon before the equal sign.

If I don't have the colon, I get an error, but perhaps for you it saves it
as some kind of text file.

--
Regards,
Tom Ogilvy

"Genesis" wrote:

I have a macro that saves the current worksheet only (fileformat=xlNormal),
and automatically generates a new filename, but formatting is lost, so
reprinting the sheet looks completely different from the original.