Saving a workbook as a .doc

alexransome

Board Regular
Joined
Jun 10, 2011
Messages
167
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

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
51,177
Office Version
365
Platform
Windows
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.
 

BlakeSkate

Well-known Member
Joined
Jan 26, 2015
Messages
517
Office Version
2016
Platform
Windows
i believe this is what you are looking for:

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

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
51,177
Office Version
365
Platform
Windows
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.
 

BlakeSkate

Well-known Member
Joined
Jan 26, 2015
Messages
517
Office Version
2016
Platform
Windows
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

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
51,177
Office Version
365
Platform
Windows
Yeah, that might be the best that you can do, other than a Mail Merge.
 

Forum statistics

Threads
1,078,437
Messages
5,340,271
Members
399,361
Latest member
Linford

Some videos you may like

This Week's Hot Topics

  • Problem with Radio Button's format control
    I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
  • Last Display on userform to a Listbox
    [CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
  • Rename and move files to a new location
    Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
  • Help with True/False Formula
    Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
  • Clear extra characters from a provided range of cells
    Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
  • Help with Current and highest streaks
    Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...
Top