macro to save current excel sheet only without losing formatting

[Guest]

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.

 

[Guest]

What file exttension are you saving XLS or CSV? CSV will not save the
formatting. I think your problem is the file extension you are using.

 

[Guest]

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.