Tuesday, February 16, 2010

Excel Plugin Application-defined or object-defined error

Dear SMSCountry Excel Plugin User,

If you are getting the following Error while send SMS from SMSCountry Excel Plugin "Application-defined or object-defined error" then please perform the following checks to resolve this issue.

Every Excel Sheet has got a unique Identity for every column as its column heading ex: A B C ... till ZZ.Inorder for us to specify column name in our excel software, we have used #A# instead of just specifying A to differentiate it from normal english characters. Since # is used by us as reserved character, issue arises when your message also as # in it.




Cause Of Error :-
The above picture shows you error which might occur when you are using #(hash) character in your message.

Solution :-
Please try sending SMS after removing # character from SMS Message...

Ex:-(Below message gives you error in Excel Plugin as Application-defined or object-defined error since there is # repeated in your message too.)
Dear #B#
Your Account # is #C#
Your Balance is #D#

To resolve the erroe you can edit message as.
Ex:-
Dear #B#
Your Account No. is #C#
Your Balance is #D#


I have removed # character from message and it works fine. As shown in above image.

That's it for this topic. If still that doesn't help then let me know so that I can give you some more solutions for it.

No comments:

Post a Comment