Runtime Error 91 : Object Variable or with block variable not set

[Ryan21]

Hi,

I get error message in excel VBA, and then my user data input. And then click on send, I get the following error!

Run-time error 91: Object variable or With block variable not set

What does this error and How can I still send my favorites ?

I have already removed the tool and once downloaded and installed again, but it continues to give the same message!

[Kirmiac]

To remove the error message "Run-time error 91: Object variable or With block variable not set" try the following:

(1) try to change If objItems (i). userProperties ( "exported") = 0
If cf.Items (i). UserProperties ( "exported")

(2) If this fails, make sure the 'exported' properties exist. From the sounds of it, which is a deprecated attribute, so you'll have to find an equivalent, perhaps viewing the properties of cf.items

[JIII]

Make sure the Recordset object is not based on the form's recordset if you plan to use the Delete or UpdateBatch methods. For an example, see the following code:

Sub Test()

   Dim rs As New ADODB.Recordset
   rs.Open "SELECT * FROM TableX", CurrentProject.Connection, _
     adOpenKeyset, adLockOptimistic
   rs.Delete
   rs.UpdateBatch

End Sub