Macro help please! How do I open a word doc, save as .txt and exit from an excel macro?

[psabin8951]

Hi All,
I have a requirement to take a filled in word form (form.dot) on a shared drive and save it as a .txt file with the same name and location (form.txt) from within an excel spreadsheet macro which resides in the same shared folder (W:\Departments\ICT_Support\Helpdesk\). How do i do this?
To give some background, the form is from an external source and cannot be changed or have a word macro embedded in it hence the need to drive this via excel.
Anyway the .txt eventually gets imported and configured to import to the next empty row in the spreadsheet. i've got the code for that bit working fine, it just the Word dot to txt conversion i cant grasp.
Any help would be appreciated.

 

[Fluff]

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

While we do allow Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule 13 here along with the explanation: Forum Rules). This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered.