Thread
:
Control a Table in Word From Excel
View Single Post
#
2
Posted to microsoft.public.excel.programming
Ardus Petus
external usenet poster
Posts: 718
Control a Table in Word From Excel
Probably a typo: yo types appword instead of appWrd
Cheers
--
AP
"Simon" a écrit dans le message de news:
...
Hi, I use code that sends a range of excel tables to bookmarks in word. It
all works well (I have modified the following code if curious
http://www.vbaexpress.com/kb/getarticle.php?kb_id=133
)
Once a table or picture is sent to word, I'd like to be able to format it
Eg
IncrementRotation -90 or wdAutoFitContent
I get a run time error on the 3rd line of the following code:
appWrd.Selection.PasteSpecial DataType:=wdPasteRTF, Placement:=wdInLine
appWrd.Selection.ParagraphFormat.Alignment = wdAlignParagraphCenter
appword.Selection.Tables(1).AutoFitBehavior (wdAutoFitContent)
I've tried a few ways of trying to pick up the table i've just created in
word, but struggling.
Any help would be appreciated.
Regards
Simon
Reply With Quote
Ardus Petus
View Public Profile
Find all posts by Ardus Petus