Most likely the installation of Office is bad on those machines which
are giving the error. Try repairing Office per the following

http://www.add-ins.com/how_to_repair_office.htm

Robert Flanagan
Add-ins.com LLC
http://www.add-ins.com
Productivity add-ins and downloadable books on VB macros for Excel


On Jun 11, 8:13*am, danny tang wrote:
Hi,

I'm converting my vba code from v2003 to v2010. However, some computers got failed when running this macro. (actually, seems only my computer can run it successfully).

example of the failu
Cells(n, ui_SmallTools.lb_OCR_wf.Listindex + 2) = Mid(Cells(n, m + 1), 1, 5)

== the 'Mid' function is not work. After checked more, the 'Left' also failed.

My IT helped to check the problems, but did have me the solution. May I know anyone can help?

Project References:
===================
These references (Libraries and Controls) may not be 64-bit compatible.
You may need to verify their compatibility. For more information see:
* * * * *http://go.microsoft.com/fwlink/?LinkId=177572
1) Microsoft Scripting Runtime, [Scripting], {420B2830-E718-11CF-893D-00A0C9054228}, C:\WINDOWS\system32\scrrun.dll
2) Microsoft Windows Common Controls-2 6.0 (SP3), [MSComCtl2], {86CF1D34-0C5F-11D2-A9FC-0000F8754DA1}, c:\windows\system32\mscomct2.ocx

also checked the microsoft site. 'left' 'mid' functions were 'Hidden'.
========================================
Note
In these tables, the status value for a given object model member may be any of the following:
Changed—The syntax for the member has changed.
Hidden—The member has been deprecated.
Removed—The member has been removed from the object model.
========================================

Many thinks. Danny.