| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
trouble using functions from Strings library
I wrote some VBA code with my excel sheet but when I run it on other
computers it does not work because it does not understand TRIM or MID. If I change the code to read Strings.Trim or Strings.Mid then it runs. What is wrong with the installation or setup on these machines that Excel does not automatically recognize these standard VBA functions? Thanks in advance, David |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
trouble using functions from Strings library
Sounds like you have a MISSING library. Check in ToolsReferences in the
VBIDE and uncheck it if so. -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "David" wrote in message ups.com... I wrote some VBA code with my excel sheet but when I run it on other computers it does not work because it does not understand TRIM or MID. If I change the code to read Strings.Trim or Strings.Mid then it runs. What is wrong with the installation or setup on these machines that Excel does not automatically recognize these standard VBA functions? Thanks in advance, David |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
trouble using functions from Strings library
Yes,
Sounds like you have a MISSING library. Check in ToolsReferences in the VBIDE and uncheck it if so. reference to VBA in particular. -- Greetings from Bavaria, Germany Helmut Weber, MVP WordVBA Win XP, Office 2003 "red.sys" & Chr$(64) & "t-online.de" |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
trouble using functions from Strings library
I think that this could be caused by any missing reference--not just to Visual
Basic for Applications. Helmut Weber wrote: Yes, Sounds like you have a MISSING library. Check in ToolsReferences in the VBIDE and uncheck it if so. reference to VBA in particular. -- Greetings from Bavaria, Germany Helmut Weber, MVP WordVBA Win XP, Office 2003 "red.sys" & Chr$(64) & "t-online.de" -- Dave Peterson |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
trouble using functions from Strings library
In fact, seeing as VBA hasn't changed since 97, it is unlikely to be
missing. -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Dave Peterson" wrote in message ... I think that this could be caused by any missing reference--not just to Visual Basic for Applications. Helmut Weber wrote: Yes, Sounds like you have a MISSING library. Check in ToolsReferences in the VBIDE and uncheck it if so. reference to VBA in particular. -- Greetings from Bavaria, Germany Helmut Weber, MVP WordVBA Win XP, Office 2003 "red.sys" & Chr$(64) & "t-online.de" -- Dave Peterson |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
trouble using functions from Strings library
The Strings library seems to be the canary in the coal mine, that fails when
any library isn't found. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Dave Peterson" wrote in message ... I think that this could be caused by any missing reference--not just to Visual Basic for Applications. Helmut Weber wrote: Yes, Sounds like you have a MISSING library. Check in ToolsReferences in the VBIDE and uncheck it if so. reference to VBA in particular. -- Greetings from Bavaria, Germany Helmut Weber, MVP WordVBA Win XP, Office 2003 "red.sys" & Chr$(64) & "t-online.de" -- Dave Peterson |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
trouble using functions from Strings library
Hi Jon,
The Strings library seems to be the canary in the coal mine, that fails when any library isn't found. exactly, now I recall. Helmut Weber |
|
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
trouble using functions from Strings library
On Jun 4, 3:56 pm, "Bob Phillips" wrote:
Sounds like you have a MISSING library. Check in ToolsReferences in the VBIDE and uncheck it if so. -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "David" wrote in message ups.com... I wrote some VBA code with my excel sheet but when I run it on other computers it does not work because it does not understand TRIM or MID. If I change the code to readStrings.Trim orStrings.Mid then it runs. What is wrong with the installation or setup on these machines that Excel does not automatically recognize these standard VBA functions? Thanks in advance, David Thanks -- very helpful. |
|
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
trouble using functions from Strings library
Does that mean that you have solved the problem?
-- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "David" wrote in message ups.com... On Jun 4, 3:56 pm, "Bob Phillips" wrote: Sounds like you have a MISSING library. Check in ToolsReferences in the VBIDE and uncheck it if so. -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "David" wrote in message ups.com... I wrote some VBA code with my excel sheet but when I run it on other computers it does not work because it does not understand TRIM or MID. If I change the code to readStrings.Trim orStrings.Mid then it runs. What is wrong with the installation or setup on these machines that Excel does not automatically recognize these standard VBA functions? Thanks in advance, David Thanks -- very helpful. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| C# Functions Library | Excel Programming | |||
| Calling functions from a xll library | Excel Programming | |||
| Creating Add-in with library of functions | Excel Programming | |||
| Creating custom library of functions/macros | Excel Programming | |||
| Newcomer to VBA; trouble with strings? | Excel Programming | |||
Hybrid Mode
