Quote Originally Posted by RobDog888
There are new extensions too. So depending on your app's automation code you will still need to update your code. .docx is the 2007 equilivalent of .doc but for files without any macros/vba code. .docm is for macro enabled documents. .dotx and .dotm also as related to templates. Then add in all the original 97-2003 extensions/file types.

Np, anytime.
So, if I understand well, this means that if you want to work on an existing Word (or Excel) document or you want to save a new one, you can't target a .doc or .xls file.

On the contrary, if you create a document on the fly, without saving it, the (pseudo)code below still works.

VB Code:
  1. Dim WApp As Object
  2.     Dim WDoc As Object
  3.    
  4.     Set WApp = CreateObject("Word.Application")
  5.     Set WDoc = WApp.Documents.Add
  6.                        
  7.     'YOUR CODE GOES HERE
  8.  
  9.     WApp.Visible = True

Please correct me if I am mistaken.