Run time error 5941

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.

--
Message posted via http://www.officekb.com

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/

"Ramon Nunez via OfficeKB.com" <forum@OfficeKB.com> wrote in message
news:49e274cc92fa4d2291424b5c18aa3563@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.
>
> --
> Message posted via http://www.officekb.com

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

"Ramon Nunez via OfficeKB.com" <forum@OfficeKB.com> wrote in message
news:49e274cc92fa4d2291424b5c18aa3563@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.
>
> --
> Message posted via http://www.officekb.com