Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Trim, Len, Left causing problem
I wrote a VBA module in which I used Trim, Len, and Left functions. When I copy the WorkBook that contains the module to different systems running different OS (Win 95/98/NT/2k) cause problem at lines containing Trim, Len and Left. I checked up Reference List it was valid. What is the fix?
Advance thanx RAJ |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Trim, Len, Left causing problem
Have you got the same version of Excel Installed on these other machines?
-- Patrick Molloy Microsoft Excel MVP --------------------------------- I Feel Great! --------------------------------- "krisrajz" wrote in message ... I wrote a VBA module in which I used Trim, Len, and Left functions. When I copy the WorkBook that contains the module to different systems running different OS (Win 95/98/NT/2k) cause problem at lines containing Trim, Len and Left. I checked up Reference List it was valid. What is the fix? Advance thanx RAJ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Trim, Len, Left causing problem
"Patrick Molloy" wrote: Have you got the same version of Excel Installed on these other machines? -- Patrick Molloy Microsoft Excel MVP --------------------------------- I Feel Great! --------------------------------- "krisrajz" wrote in message ... I wrote a VBA module in which I used Trim, Len, and Left functions. When I copy the WorkBook that contains the module to different systems running different OS (Win 95/98/NT/2k) cause problem at lines containing Trim, Len and Left. I checked up Reference List it was valid. What is the fix? Advance thanx RAJ Yeah. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Trim, Len, Left causing problem
I'd take a closer look at Tools|References (make sure your project is active in
the VBE, too). Look for MISSING in that dialog. If (when) you find it, you'll have to decide if you need it. If you do, you may want to go back to the developer pc and convert your code to use late binding instead of using the references. Dick Kusleika has a web page at: http://www.dicks-clicks.com/excel/olBinding.htm that explains this difference when using Outlook It's very nice to use early binding when developing. You get all the intellisense help (when you set the reference and declare the variables nicely). But before you distribute it to users (who may be using different versions), it's usually a good idea to use latebinding (and change those object variable declarations to the generic "As Object".) krisrajz wrote: I wrote a VBA module in which I used Trim, Len, and Left functions. When I copy the WorkBook that contains the module to different systems running different OS (Win 95/98/NT/2k) cause problem at lines containing Trim, Len and Left. I checked up Reference List it was valid. What is the fix? Advance thanx RAJ -- Dave Peterson |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Trim, Len, Left causing problem
Here are some more extensive references on binding:
Use late binding - don't have a reference to excel. http://support.microsoft.com/default...b;EN-US;244167 INFO: Writing Automation Clients for Multiple Office Versions http://support.microsoft.com/default...b;en-us;245115 INFO: Using Early Binding and Late Binding in Automation http://support.microsoft.com/default...b;en-us;247579 INFO: Use DISPID Binding to Automate Office Applications Whenever Possible However, if the problem is caused by going from a newer version of Excel to an older version, the solution might be to do the development on the oldest version. -- Regards, Tom Ogilvy "Dave Peterson" wrote in message ... I'd take a closer look at Tools|References (make sure your project is active in the VBE, too). Look for MISSING in that dialog. If (when) you find it, you'll have to decide if you need it. If you do, you may want to go back to the developer pc and convert your code to use late binding instead of using the references. Dick Kusleika has a web page at: http://www.dicks-clicks.com/excel/olBinding.htm that explains this difference when using Outlook It's very nice to use early binding when developing. You get all the intellisense help (when you set the reference and declare the variables nicely). But before you distribute it to users (who may be using different versions), it's usually a good idea to use latebinding (and change those object variable declarations to the generic "As Object".) krisrajz wrote: I wrote a VBA module in which I used Trim, Len, and Left functions. When I copy the WorkBook that contains the module to different systems running different OS (Win 95/98/NT/2k) cause problem at lines containing Trim, Len and Left. I checked up Reference List it was valid. What is the fix? Advance thanx RAJ -- Dave Peterson |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Trim, Len, Left causing problem
Kris,
I ran into the same problem myself. None of the requisite References were Missing and I eventually solved the problem by prefixing the Trim, Len, Left (and for good measure Right and Mid) functions with the four characters "VBA." E.g., x = VBA.Left(y,3), etc. To shorten the keystrokes as I develop programs, I actually code this example as x = Lft(y,3) and then in a code module have: Function Lft(StringVar As Variant, NCharacters As Long) As String Lft = VBA.Left(StringVar, NCharacters) End Function -- Dennis Eisen |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
trim everything from left of first underscore in the text? | Excel Worksheet Functions | |||
TRIM, LEFT, RIGHT | Excel Worksheet Functions | |||
Text Causing a Problem in Formula | Excel Discussion (Misc queries) | |||
left trim | Excel Worksheet Functions | |||
minus numbers causing a problem | New Users to Excel |