Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi everybody,
with a new machine (Vista Small Business, Office XP) and all references set, Word running, like done a hundred times before, yet, Dim oWrd As Word.Application Set oWrd = GetObject(, "Word.Application") ' type mismatch same when trying to control Word from Powerpoint. From Word, this is not a problem: Dim oExc As Excel.Application Set oExc = GetObject(, "Excel.application") ' fine -- Greetings from Bavaria, Germany Helmut Weber, MVP WordVBA Vista Small Business, Office XP |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I use this with WinXP Home and Office 2003:
Dim oWord as Word.Application On Error Resume Next Set oWord = GetObject(, "Word.Application") If Err.number < 0 Then Set oWord = CreateObject("Word.Application") End If Helmut Weber wrote: Hi everybody, with a new machine (Vista Small Business, Office XP) and all references set, Word running, like done a hundred times before, yet, Dim oWrd As Word.Application Set oWrd = GetObject(, "Word.Application") ' type mismatch same when trying to control Word from Powerpoint. From Word, this is not a problem: Dim oExc As Excel.Application Set oExc = GetObject(, "Excel.application") ' fine -- Greetings from Bavaria, Germany Helmut Weber, MVP WordVBA Vista Small Business, Office XP -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
object on RHS when there is a type-mismatch | Excel Programming | |||
Type Mismatch: array or user defined type expected | Excel Programming | |||
Setting range object--Type mismatch if template not used | Excel Programming | |||
Type mismatch using rnge as Range with Type 8 Input Box | Excel Programming | |||
Help: Compile error: type mismatch: array or user defined type expected | Excel Programming |