Runtime Error 1004 - File Format Invalid

Good Day,

I am trying to open up a word file via Excel VBA and am encountering a problem I've not before. Looking for some assistance.

Here is my code:

Please Login or Register  to view this content.

It seems to be a pretty simple code and I currently use the same code in other Macros to open other Excel files, however, this is my first for trying to open a word document.

The error I am receiving is "Run-time error '1004': Test.docx: file format is not valid."

This is a brand new file I've created just for testing purposes.

Thoughts?

use the same code in other Macros to open other Excel files

Perhaps, but this isn't an Excel file and Excel knows nothing about the format of Word files...

Maybe if you explained what you are trying to do?

Hi cytop,

Thanks for the reply.

What I am trying to do is open a Word document using VBA within an Excel document. That's it.

In the overall scheme of things, I am wanting to populate columns within the word document using information from the Excel document.

But, this is the first part. Once I get this down, I can focus on the other parts. This is my first foray into Word manipulation using Excel.

Thank you