Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Why this don't work
Hi Excel Experts:
Why this code don`t work, I already create a reference to the Word type library Sub WordControl() Dim appWd As Word.Application 'line of error Set appWd = Application.ActivateMicrosoftApp xlMicrosoftWord ...More lines of code appWd.Quit End Sub Win XP pro, Excel 2002 Thanks for any advice Regards Fernando Ortiz |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Why this don't work
ActivateMicrosoftApp does not return a reference to the activated
application. Instead, use GetObject. Set appWd = GetObject(,"Word.Application") -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Fernando Ortiz" wrote in message ... Hi Excel Experts: Why this code don`t work, I already create a reference to the Word type library Sub WordControl() Dim appWd As Word.Application 'line of error Set appWd = Application.ActivateMicrosoftApp xlMicrosoftWord ...More lines of code appWd.Quit End Sub Win XP pro, Excel 2002 Thanks for any advice Regards Fernando Ortiz |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro to update a column in a work based on another work sheet | New Users to Excel | |||
how can i automatically generate work order numbers from work orde | Excel Discussion (Misc queries) | |||
flash object dont work in my excel work sheet | Excel Discussion (Misc queries) | |||
Counting dates in multiple work sheets and work books | Excel Discussion (Misc queries) | |||
Is there away to keep "auto save" from jumping to the first work sheet in the work book? | New Users to Excel |