Hi all,

Document is not empty, macro is pasting some text and values from excel to word.
The thing is, when I SaveAs manually .docm to .docx (after macro run), it saves correctly and .docx opening without any trouble.
When I use code from first message to auto save and the end of macro work, it gives me corrupt error.



Quote Originally Posted by Dave View Post
I think U need to use SaveAs2 when changing the file extension. HTH. Dave
I tried SaveAs2 instead of SaveAs but corruption still remains.

Quote Originally Posted by Paul_Hossler View Post
Is the "" supposed to be "<space>" ?
Yes, it is space.