VBA problems with windows 98 and office 2000 
Author Message
 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
.



Mon, 16 Feb 2004 16:00:00 GMT  
 VBA problems with windows 98 and office 2000
Hi Susan,

If you really do have two periods before text, then that is your problem.

Please post any response to the newsgroups for the benefit of others who may
also be following the thread.

Hope this helps,
Doug Robbins - Word MVP

Quote:
> 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
> .



Tue, 17 Feb 2004 18:03:02 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. VBA problems Going from Windows 98 to Windows 2000

2. Office Automation Problem 98,2000

3. Proj 98 VBA vs Proj 2000 VBA

4. Any Windows 98 and Office 98 issues?

5. Type Name is Invalid error -- Windows 2000/98 application with SQL Server/stored procedure problem

6. ExtCreatePen does not work in Windows 2000 but works in Windows 98

7. vba problem or windows 98??

8. Format$ in Access 2000 on Windows 98

9. Getting the serial nbr of WIndows 98/2000/ME etc

10. Rich Text on Window 95,98, 2000 and NT

11. ADO 2.0 to 2.6, Window 98, NT and 2000

12. Windows NT/2000 and 95/98 shell32.dll difference

 

 
Powered by phpBB® Forum Software