hi,
i have a macro that opens a word file(.docm) paste data in it then save as another filename using the below code
but it saves it also as a ".docm"
how do i save it as a ".docx"?
objDoc.SaveAs Filename:=xlRng.Offset(0, -1).Value objDoc.Saved = True
All you need is to include the FileFormat. Try this...
objDoc.SaveAs fileName:=xlRng.Offset(0, -1).Value, FileFormat:=12
Regards
sktneer
Treat people the way you want to be treated. Talk to people the way you want to be talked to.
Respect is earned NOT given.
hi,
thanks for the reply
i googled what 12 means, msdn says its an xml format
msdn says the docx format is 16
used
its saved as a docx formatobjDoc.SaveAs fileName:=xlRng.Offset(0, -1).Value, FileFormat:=16
thanks again for the additional code
Last edited by k1dr0ck; 03-21-2018 at 02:55 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks