Excel to save files as .Doc

[ipbr21054]

Morning,
When using Excel i save a document for printing as a PDF but now i need to test something out.

I will use a command button to run the code & it will then print out my print area specified.
I would just like it to save as .Doc

So far i am unable to find such a basic thing when searching.

Path to save file to is C:\Users\Ian\Desktop\TEST INVOICES
Thanks

 

[Joe4]

You cannot save an Excel directly to a Word document.
Typically, you would merge Excel data into a Word document using the "Mail Merge" functionality in Word.

There are other ways to convert Excel files to Word documents.
See here: How to Convert Microsoft Excel to Word: 3 Simple Ways.

 

[ipbr21054]

OK thanks for the reply