danny tang explained :
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.

You may need to reset (in References) these to run the x64 version (if
available).

Also, the DLL and OCX you ref may not be installed on the OS, and these
are both x32 NOT x64. (In Win7, scrun.dll is in System32 folder;
mscomct2.ocx is not installed)

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion