Open a word doc, save as a text file, return to excel

[PSabin8951]

Hi all,
First of all apologies as i'm a complete newbie when it comes to VBA!
Ok so i have a spreadsheet which imports the contents of a text file into the next row of an existing spreadsheet doc. I've got that all working fine, but the text file comes from a word form filled out by other users and currently i have to go in to the form and save it as a .txt file then come out and import it in to my spreadsheet.
What I want to do is make this automated. The form itself will always have the same name and file location.
So basically i need to:-
Open Excel spreadsheet and run a macro which:-
Opens a specific word document
Saves that document to a specific location as a .txt file
exits Word
returns to Spreadsheet.

I'm thinking this would be a sub routine so I can run this before i run my other subroutine to take the result and place it in my spreadsheet.

I've tried doing this myself and can get a word doc to open but can't get the doc to save sensibly and in the right format.
Any help would be appreciated.
Thanks in advance.

[Pepe Le Mokko]

Administrative note

Welcome to the forum

in your haste to solve your problem, you probably missed the yellow banner advising how to get answers faster by posting a sheet ?

Please take a moment to read it and attach a sheet accordingly.

Thanks you for helping us help you

Please also post the code you have already created

[PSabin8951]

ok so this is how im opening the doc...

Please Login or Register  to view this content.

But i dont know where to go from here.

[Pepe Le Mokko]

Thanks
In the future please wrap code with code tags. I did it for you this time

[PSabin8951]

Will do Pepe.
Can anyone help with this?

[Marc L]

(removed 'cause of wild cross-posting)

[Pepe Le Mokko]

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.

Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.

As you are new I will add it for you.Please read forum rules

https://www.mrexcel.com/board/thread...macro.1129324/