Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I need to import a number of text lines from Word file into Excel. Using what
I found from postings here on importing tables and the Word macro recorder I have the following partial code: FName = Application _ .GetOpenFilename("Word Files (*.doc), *.doc") Set oWord = GetObject(FName) With oWord.Find .Text = "Seq." .Replacement.Text = "" .... End With 'oWord Selection.Find.Execute Selection.MoveRight Unit:=wdCharacter, Count:=66, Extend:=wdExtend Selection.MoveDown Unit:=wdLine, Count:=100, Extend:=wdExtend Selection.Copy Cells("A1").Activate ActiveSheet.Paste However, Excel VBA doesn't know wdCharacter or wdLine. It doesn't know wdForward if I try a Move function. The number of lines of text to import is constant. Any workarounds would be greatly appreciated! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
IMPORTING WORD TO EXCEL | Excel Programming | |||
After importing MS Word text, all cells are filled with ##### | Excel Discussion (Misc queries) | |||
Importing from excel to word | Excel Discussion (Misc queries) | |||
Importing text from a Word bookmark into a spreadsheet | Excel Programming | |||
importing text from bookmark in Word to excel | Excel Programming |