Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi,
I'm using this macro : Range("A1").Select Selection.Copy Const wdAlignParagraphCenter = 1 Set WordApp = CreateObject("Word.Application") With WordApp .Visible = True .Documents.Add With .Selection .Paste .ParagraphFormat.Alignment = wdAlignParagraphCenter .PageSetup.TopMargin = 36 End With End With Sheets("Quotation").Select Now I want to make a new macro that does the same, but not opens Word but switches to word when it is already open. (it has to create a new doc in word that is already open) Is this possible ? How can I do this ? Thx in advance! Tom |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel to Word Macro | Excel Discussion (Misc queries) | |||
Macro switch between windows question | Excel Discussion (Misc queries) | |||
passing arguments from an excel macro to a word macro | Excel Discussion (Misc queries) | |||
Macro - Open Word with Excel macro | Excel Discussion (Misc queries) | |||
Using Word and Excel in one Macro | Excel Programming |