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.

I don't see how this ever worked as Clear is a method which you can apply to
certain objects, such as the Err object, it is not a value you can assign.

So try something like

VendorForm.txt_s_cid.value = ""

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Daniel" wrote in message
om...
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.

Instead of = Clear try using = "" .

Sharad


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

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.