Saving a workbook as a .doc

[alexransome]

Hello,

Is it possible to use VBA code to save a workbook as a word doc.

I've seen that you can manually save the file and Ron de Bruin uses an example that saves files in different formats of excel.

Thanks for any help.

 

[Joe4]

I don't think so. They are not compatible.
What would that even look like?
What is it exactly that you are trying to do?
If you are trying to export Excel data to Word, a common way to do it is through a Mail Merge.

 

[DataBlake]

i believe this is what you are looking for:

Home - Algorithms

Learn and solve top companies interview problems on data structures and algorithms

excel-macro.tutorialhorizon.com

if not try recording a macro when you manage to use the manual example and that should show how to do it. without seeing the manual example i would have 0 clue as my version of excel can't save as doc file without doing the way in the tutorial i posted.

 

[Joe4]

Blake, that tutorial looks like it is for creating a Word document via Excel VBA and saving it, but they said:

use VBA code to save a workbook as a word doc

which sounds to me like converting an Excel document to a Word document, which would be something totally different.

 

[DataBlake]

which sounds to me like converting an Excel document to a Word document, which would be something totally different.

ah yeah you may be right, but this is about as close as i would be able to tell to "saving a workbook as a word doc".
create a doc, transfer the selection of text, save the doc. right? I'm not especially well versed in word because i use other programs for text based things so i could be entirely wrong, but i don't see any other way to do it.

 

[Joe4]

Yeah, that might be the best that you can do, other than a Mail Merge.

 

[alexransome]

Thanks foe the comments. I'll try the ideas out.