Excel VBA Save AS (word document) not working with Word 2010

[jscranton]

I have a long bit of code that at one point saves a Word document and then saves it again with a new name and the old (legacy) .doc extension.

This all works find when the user is running Office 2007. However, it errors out for anyone using Office 2010. The reference libraries are all correct (as far as I know).

Can anyone point me towards a solution.

    Dim myDoc As Word.Document
    Dim saveAsName as String

    saveAsName = "some text here" + ".doc"
   
    myDoc.Save
    
    myDoc.SaveAs fileName:=(saveAsName), FileFormat:=wdFormatDocument

 

[jscranton]

Andrew,

As always, thanks for your help. I tried the script on another computer running 2010 and worked fine there as well so it must be some local profile issue.

If you are ever in Raleigh, drinks are on me.

J.