References.
 

Hello,

I am using Office 2003 and I create some macro in excel. In this macro I am
using word application:

Set oWRDapp = CreateObject("WORD.Application")
Set oWRDdoc = oWRDapp.Documents
oWRDdoc.Add DocumentType:=0
....

Excel automaticly add refernces to "Microsoft Word 11.0 Object Libary". But
when I run this macro on computer where is install Office 2002 it dosnt work
because macro looking for Office 11. So i have to manualy change references
from Office10 to 10.

Do you know how can I correct this. Its possible do this change by macro?
Somethnig like:

if install office 2002 then referneces = Office10
if install office 2003 then referneces = Office11

Thanks Tom

References.
 

Dim oWRDapp As Object


Set oWRDapp = CreateObject("WORD.Application")
Set oWRDdoc = oWRDapp.Documents
oWRDdoc.Add DocumentType:=0

and remove the refernce to Word, OR

develop code on the lower version of Excel

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Tom" wrote in message
...
Hello,

I am using Office 2003 and I create some macro in excel. In this macro I
am
using word application:

Set oWRDapp = CreateObject("WORD.Application")
Set oWRDdoc = oWRDapp.Documents
oWRDdoc.Add DocumentType:=0
....

Excel automaticly add refernces to "Microsoft Word 11.0 Object Libary".
But
when I run this macro on computer where is install Office 2002 it dosnt
work
because macro looking for Office 11. So i have to manualy change
references
from Office10 to 10.

Do you know how can I correct this. Its possible do this change by macro?
Somethnig like:

if install office 2002 then referneces = Office10
if install office 2003 then referneces = Office11

Thanks Tom

References.
 

Thanks,
and how can I remove the refernce ?

Tom

"Bob Phillips" wrote in message
...
Dim oWRDapp As Object


Set oWRDapp = CreateObject("WORD.Application")
Set oWRDdoc = oWRDapp.Documents
oWRDdoc.Add DocumentType:=0

and remove the refernce to Word, OR

develop code on the lower version of Excel

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Tom" wrote in message
...
Hello,

I am using Office 2003 and I create some macro in excel. In this macro I
am
using word application:

Set oWRDapp = CreateObject("WORD.Application")
Set oWRDdoc = oWRDapp.Documents
oWRDdoc.Add DocumentType:=0
....

Excel automaticly add refernces to "Microsoft Word 11.0 Object Libary".
But
when I run this macro on computer where is install Office 2002 it dosnt
work
because macro looking for Office 11. So i have to manualy change
references
from Office10 to 10.

Do you know how can I correct this. Its possible do this change by macro?
Somethnig like:

if install office 2002 then referneces = Office10
if install office 2003 then referneces = Office11

Thanks Tom

References.
 

Go into ToolsReferences in the VBE, and uncheck that item.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Tom" wrote in message
...
Thanks,
and how can I remove the refernce ?

Tom

"Bob Phillips" wrote in message
...
Dim oWRDapp As Object


Set oWRDapp = CreateObject("WORD.Application")
Set oWRDdoc = oWRDapp.Documents
oWRDdoc.Add DocumentType:=0

and remove the refernce to Word, OR

develop code on the lower version of Excel

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Tom" wrote in message
...
Hello,

I am using Office 2003 and I create some macro in excel. In this macro
I
am
using word application:

Set oWRDapp = CreateObject("WORD.Application")
Set oWRDdoc = oWRDapp.Documents
oWRDdoc.Add DocumentType:=0
....

Excel automaticly add refernces to "Microsoft Word 11.0 Object Libary".
But
when I run this macro on computer where is install Office 2002 it dosnt
work
because macro looking for Office 11. So i have to manualy change
references
from Office10 to 10.

Do you know how can I correct this. Its possible do this change by
macro?
Somethnig like:

if install office 2002 then referneces = Office10
if install office 2003 then referneces = Office11

Thanks Tom

References.
 

Yes I know this. But how can I add references?
This dobt do it:
Set oWRDapp = CreateObject("WORD.Application")
Set oWRDdoc = oWRDapp.Documents
oWRDdoc.Add DocumentType:=0

I have to do it manualy in refences tab.

tom

References.
 

What? You asked how to remove a reference not add it.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Tom" wrote in message
...
Yes I know this. But how can I add references?
This dobt do it:
Set oWRDapp = CreateObject("WORD.Application")
Set oWRDdoc = oWRDapp.Documents
oWRDdoc.Add DocumentType:=0

I have to do it manualy in refences tab.

tom