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.

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

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.