LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default exporting data to appear at Bookmarks in a Word Document

Hi - I just posted this query but forgot to include my sample VBA code -
oops! hope its been deleted as being obviously missing something.

I'm stuck so I'm calling Ghost Busters!

I need a macro to copy text from various cells (plus a graph), open a Word
document and insert the strings of text one by one at various Bookmarks ...

Below is one of the macros I've been trying to get working, and it feels I'm
pretty close but just can't seem to be able to select anything in Excel to
copy to Word

What am I doing wrong?
----------------------------------------------------------------------
Sub BookMark()

Dim wordApp As Word.Application

Set wordApp = CreateObject("Word.Application")

With wordApp

.Visible = True
.Documents.Open Filename:="G:\BRIAN Phase 3\BRIAN_Report_Form.doc",
ReadOnly:=True


.ActiveDocument.Bookmarks("SEName").Select
.Selection.Text = Sheets("Action_Points").Text1

End With

Set wordApp = Nothing

End Sub
-------------------------------------------------------------------------
Thanks in advance

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Cross reference bookmarks in a Microsoft word document FredN Excel Discussion (Misc queries) 0 April 7th 08 04:33 PM
Bookmarks and exporting data into Excel Bri Excel Discussion (Misc queries) 1 February 27th 07 09:30 PM
exporting Excel data to Word using Bookmarks Dave Kilroy Excel Programming 0 May 19th 05 05:33 PM
Checking for bookmarks in Word document jag Excel Programming 2 June 14th 04 02:15 AM
Exporting text to a Word document Ian M[_2_] Excel Programming 1 May 3rd 04 04:25 AM


All times are GMT +1. The time now is 12:02 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"