how do i open a dotx file using excel macro?

You will want to use the .Add method instead of .Open and specify the Template argument.

Set WordDoc = WordApp.Documents.Add(Template:=File)

Keep in mind this new document will not have a filename when it is created.

CLICK HERE to find out more related problems solutions.

Leave a Comment

Your email address will not be published.

Scroll to Top