MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Exporting Data from Excel to Word

  Asked By: Adelisa    Date: Mar 03    Category: MS Office    Views: 949

I am currently exporting data from my excel spreadsheet to Word
using the following code.

Private Sub CommandButton3_Click()
Dim WordApp As Object
Set WordApp = CreateObject("Word.Application")
WordApp.Documents.Add "C:\edmund.dot"
WordApp.Visible = True
WordApp.Run "copy"
End Sub

When I run this at home it works (using office 2000)

At work they only have Office 97 and where cells have been
merged, word ignores it and restricts the data to the first cell. Is
there any way around this in Office 97.

When the word application is opened is at also possible to
automatically set the margins so that the data fits on one page



1 Answer Found

Answer #1    Answered By: Sadie Black     Answered On: Mar 03

I would also like to add  a further question. Is it possible to get
the marco to automatically save the word  document that has been
created in a specified directory each time, using a value from one
of the excel  cells as the file name?

Didn't find what you were looking for? Find more on Exporting Data from Excel to Word Or get search suggestion and latest updates.