Run time error 5941

[Ramon Nunez via OfficeKB.com]

I create a form in office 2000 which run fine, but when user open it on office 97, I got the message:
run-time error 5941
the requested member of the collection does not exist.

On the form I populate some formfields with data inserted by user.
Any ideas why the forms works fine on office 2000 or XP but not on 97.

The way I assign values to formfiels is like this:
Dim strCltAddress As String
strCltAddress = frmUserInfo.txtAddress.Text
ActiveDocument.FormFields("ClaimantAddress").Result = strCltAddress

which creates the error.

 

[Colo]

Please look into Resize property in the VBA help.
Your code can be written like this.

Range("A1").Offset(4, 1).Resize(1, 9).Copy


Regards,
Colo
http://www.puremis.net/excel/

 

[NickHK]

Ramon,
Office 2K VBA Object Browser, returns No Items Found for "FormFields".
After some hunting, I found FormFields in Word.
So is this anything to do with Excel ?

NickHK