Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.tables
|
|||
|
|||
Macro for word tables to excel
There are lots of posts asking how to write a macro exporting a word
table to excel 2003. This is probably the most simple macro for this task: Sub GetWordTable() Dim wdap As Word.Application Dim wddc As Word.Document Dim wdtbl As Word.Table Set wdap = GetObject(, "word.application") Set wddc = wdap.ActiveDocument Set wdtbl = wddc.Tables(1) wdtbl.Range.Cut ActiveSheet.Paste End Sub |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro execution using MailMerge | Mailmerge | |||
Importing tables from Excel | New Users | |||
wordcount macro for tables and brackets | Tables | |||
Inserting Excel tables into Word | Microsoft Word Help | |||
How stable are tables paste-linked from Excel XP into Word XP | Microsoft Word Help |