Manipulating Word Range from Excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am juggling a couple of Microsoft application objects from within Excel VBA
Add-In.

Basically, I am creating an draft email using an Outlook object and using
Word object as editor (in Outlook) - all with Office 2003.

All working fine on a couple of machines but on one machine (same build as
others) the code is failing during a Find/Replace in the Word Range object.
It is actually causing Excel to crash with a 'Send to Microsoft' memory stack
error.

The code is roughly from memory :-

Dim WdDoc as Document
Dim WdRg as Range

Set wdDoc = OutLookobj.ActiveEditor (or similar)
Set WdRg = WdDoc.Range(2,100) ' assume text fred somewhere in this range

WdRg.Find.Text = "fred"
WdRg.Replacement.Text = "bert"
WdRg.Find.Execute

Any thoughts why the code should fail (big time, taking out Excel) just on
one machine but works OK on the other clone builds? A User option or Add-In
conflict?

Thanks,
Andy.
 
You will most likely get an answer if you re-post this to an Excel nesgroup.

The access and modulescdaovba in this news group's name refers to Microsoft
Access (a database program) coding.

Fred
 
Back
Top