#1
|
|||
|
|||
Pick up data from Word documenta
How can I pick up data from Word document in Excel? I marked data with bookmarks and I need code for picking up data from bookmarks?
Thanks in advance |
#2
|
|||
|
|||
Hi,jmarin
here is a sample, hope can help you. Code:
Sub test() Dim wrdApp As Object Dim myDoc As Object Set wrdApp = CreateObject("Word.Application") With wrdApp .Visible = False Set myDoc = .Documents.Open("e:\test.doc") myDoc.Bookmarks("Region").Range.Copy Sheet1.Range("A1").PasteSpecial xlPasteValues Application.CutCopyMode = False End With myDoc.Close True wrdApp.Quit Set myDoc = Nothing Set wrdApp = Nothing End Sub |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Graphing in Excel - one plot many columns/pick one column | jerryjaysr | Excel | 4 | 06-29-2006 07:27 AM |