
VBA problems with windows 98 and office 2000
Hi,
I desparately need some help.
There seems to be an incompatibilty issue with windows 98
and word 2000 when running OLE Automation process. I am
basically trying to automate the transfer of some data
from an excel spreadsheet into a word document using the
find and replacement method. My procedure works when I run
a colleagues PC which uses windows 95 and office 2000,
however it doesn't run on mine. The only difference is the
different windows platform. The error message I get is
error5 - invalid call or arguement. When going into
help,this suggests some problems due to the platform I am
using. It is not the code itself cos it works on windows
95. Please see the problem code below.
I've tried looking and searching everywhere for a solution
and cannot find one. I've read lots of literature which
does acknowledge that there are compatibilty issues but I
can't a solution anywhere.
Can anyone please help. This is my last resort. I do not
know where else to seek help.
This is the part I'm having trouble with. Error message
appears from the second line (.text).
With ActiveDocument.Content.Find
..Text = "ddy"
..Replacement.Text = cdy
..Execute Replace:=wdReplaceAll, Forward:=True
End With
Thanks in advance
Susan
.