If it ever worked, you had probably declared Clear and assigned it a
value of "" (i.e., a zero length string) or zero. Maybe, something
like

Const Clear as string=""

or

Dim Clear as Integer:Clear=0

That said, I probably would not use Clear as a user defined token since
there are three methods (Excel, MS Forms, and VBA) named Clear. For
which, search the XL VBA help.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article ,
says...
http://personal.cityu.edu.hk/~503965...g_errorMsg.jpg
Here is the screen of the error message I am facing. I have developed
a macro for inputting data in the platform of WinXP(Home) with office
XP. It works well in other computer of the same platform. However,
when I tried to use the macro on the older platform Win98 + office 97.
The error indicate that the library is not found. I thought the
problem was the version of the Microsoft office. So I installed a
office XP on that computer. However, problem is still occured. Is
there any way can solve my problem? Is the library belong to the
operating system or the microsoft office actually?
Do I need to upgrade the operating system to XP to solve this problem?

Thanks.