Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can't find String functions.... Missing library
I have written a VBA Excel Add-in that works fine on my development
machine running XP pro, using Excel 2002 installed as part of Office 10. I have another machine running XP Home edition with the same Office 10 and Excel running. On that machine some functions won't run because it can't find the libraries with the built-in string functions, e.g., Mid(), Trim(), UCase(). I did a reinstall/repair on Office, but no help. Any thoughts? TIA Ed |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can't find String functions.... Missing library
In the VBA editor, click on Tools/References and see if anything is marked
as "Missing". If so, check the item or items and then try your code again. Rick "Ed" wrote in message ... I have written a VBA Excel Add-in that works fine on my development machine running XP pro, using Excel 2002 installed as part of Office 10. I have another machine running XP Home edition with the same Office 10 and Excel running. On that machine some functions won't run because it can't find the libraries with the built-in string functions, e.g., Mid(), Trim(), UCase(). I did a reinstall/repair on Office, but no help. Any thoughts? TIA Ed |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can't find String functions.... Missing library
on the problematic machine, after the error, go into tools=References in the
VBE and you should see one or more references marked as MISSING. Fix these references as they are the source of your problem (high probability they have nothing to do with the string library). Or look in your own machine and see what references you have in this workbook that are not likely to be in your users environment. -- Regards, Tom Ogilvy "Ed" wrote: I have written a VBA Excel Add-in that works fine on my development machine running XP pro, using Excel 2002 installed as part of Office 10. I have another machine running XP Home edition with the same Office 10 and Excel running. On that machine some functions won't run because it can't find the libraries with the built-in string functions, e.g., Mid(), Trim(), UCase(). I did a reinstall/repair on Office, but no help. Any thoughts? TIA Ed |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can't find String functions.... Missing library
"Rick Rothstein \(MVP - VB\)" wrote...
In the VBA editor, click on Tools/References and see if anything is marked as "Missing". If so, check the item or items and then try your code again. .... "Ed" wrote in message . . . e.g., Mid(), Trim(), UCase(). . . . Mid, Trim and UCase are built into VBA itself. OP would have had to have removed references to VBA itself, but that'd mean more than just the string functions would have failed. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can't find String functions.... Missing library
In the VBA editor, click on Tools/References and see if anything
is marked as "Missing". If so, check the item or items and then try your code again. ... "Ed" wrote in message . . . e.g., Mid(), Trim(), UCase(). . . . Mid, Trim and UCase are built into VBA itself. OP would have had to have removed references to VBA itself, but that'd mean more than just the string functions would have failed. Well, the OP did say "e.g. (for example)"<g, so he may only be reporting String function because they are what he saw first. As for the OP removing the reference... I don't think he can... however, for reasons I have never been able to find out (over in the compiled VB side of thing, at least), the system can decide, on its own, to remove one or more references. When it does, the kind of problems the OP is reporting usually is the result. The only other way I've seen these commands cease working is when a variable in the same scope as the attempted function call is named the same as the built-in function (for example, naming a module level variable mID... short for module ID). However, this seems unlikely here because of the number of functions involved. Rick |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can't find String functions.... Missing library
In excel VBA, this is a consistent indicator of exaclty what you said - a
Missing reference not related to VBA. Why it always seems to flag a VBA built in function I can't say - perhaps it is the first time it consults the references - but invarialble the answer that corrects this problem is to fix the MISSING reference. -- Regards, Tom Ogilvy "Rick Rothstein (MVP - VB)" wrote: In the VBA editor, click on Tools/References and see if anything is marked as "Missing". If so, check the item or items and then try your code again. ... "Ed" wrote in message . . . e.g., Mid(), Trim(), UCase(). . . . Mid, Trim and UCase are built into VBA itself. OP would have had to have removed references to VBA itself, but that'd mean more than just the string functions would have failed. Well, the OP did say "e.g. (for example)"<g, so he may only be reporting String function because they are what he saw first. As for the OP removing the reference... I don't think he can... however, for reasons I have never been able to find out (over in the compiled VB side of thing, at least), the system can decide, on its own, to remove one or more references. When it does, the kind of problems the OP is reporting usually is the result. The only other way I've seen these commands cease working is when a variable in the same scope as the attempted function call is named the same as the built-in function (for example, naming a module level variable mID... short for module ID). However, this seems unlikely here because of the number of functions involved. Rick |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can't find String functions.... Missing library
Harlan Grove wrote:
"Rick Rothstein \(MVP - VB\)" wrote... In the VBA editor, click on Tools/References and see if anything is marked as "Missing". If so, check the item or items and then try your code again. ... "Ed" wrote in message . . . e.g., Mid(), Trim(), UCase(). . . . Mid, Trim and UCase are built into VBA itself. OP would have had to have removed references to VBA itself, but that'd mean more than just the string functions would have failed. As Dave Peterson said in the thread "Select Case Syntax" on July 15th, "And the part that makes it really confusing is that if you're missing a reference, then the line that is marked with an error may not have anything to do with anything in that reference." In that thread the failing commands were Mid, Right and Len, and the missing Library was ArrayAdd-Ins.xls. Go figure. Alan Beban |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can't find String functions.... Missing library
You're right. It says that Microsoft MSM Merge Type library is
missing. Wonder why? As I said, I did a repair of the installation off the Office 10 CD. Also, the test machine is my wife's, in a room across the hall. I'm a bit worried that it might fail on another machine a bit more difficult for me to get at and fix. Thanks to Tom and others who identified the problem. Ed "Tom Ogilvy" wrote in message ... on the problematic machine, after the error, go into tools=References in the VBE and you should see one or more references marked as MISSING. Fix these references as they are the source of your problem (high probability they have nothing to do with the string library). Or look in your own machine and see what references you have in this workbook that are not likely to be in your users environment. -- Regards, Tom Ogilvy |
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can't find String functions.... Missing library
I now see that I am runing Excel 2002 SP3 on my development machine
and no SPs at all on the other machine. Gotta figure out how to get teh SP now.... Ed "Ed" wrote in message ... You're right. It says that Microsoft MSM Merge Type library is missing. Wonder why? As I said, I did a repair of the installation off the Office 10 CD. Also, the test machine is my wife's, in a room across the hall. I'm a bit worried that it might fail on another machine a bit more difficult for me to get at and fix. Thanks to Tom and others who identified the problem. Ed "Tom Ogilvy" wrote in message ... on the problematic machine, after the error, go into tools=References in the VBE and you should see one or more references marked as MISSING. Fix these references as they are the source of your problem (high probability they have nothing to do with the string library). Or look in your own machine and see what references you have in this workbook that are not likely to be in your users environment. -- Regards, Tom Ogilvy |
#10
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can't find String functions.... Missing library
The missing file is apparently mergemod.dll in C:\Program Files\Common
Files\Microsoft Shared\MSI Tools on my development machine, which seems to be running Excel 2002 SP3. There is no such file or directory on the 2nd machine which is running without any SPs. Ed "Ed" wrote in message ... You're right. It says that Microsoft MSM Merge Type library is missing. Wonder why? As I said, I did a repair of the installation off the Office 10 CD. Also, the test machine is my wife's, in a room across the hall. I'm a bit worried that it might fail on another machine a bit more difficult for me to get at and fix. Thanks to Tom and others who identified the problem. Ed "Tom Ogilvy" wrote in message ... on the problematic machine, after the error, go into tools=References in the VBE and you should see one or more references marked as MISSING. Fix these references as they are the source of your problem (high probability they have nothing to do with the string library). Or look in your own machine and see what references you have in this workbook that are not likely to be in your users environment. -- Regards, Tom Ogilvy |
#11
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can't find String functions.... Missing library
this is from MSDN
Merge Modules Merge modules provide a standard method by which developers deliver shared Windows Installer components and setup logic to their applications. Merge modules are used to deliver shared code, files, resources, registry entries, and setup logic to applications as a single compound file. Developers authoring new merge modules or using existing merge modules should follow the standard outlined in this section. . . . My guess would be that you don't need this and it has nothing to do with Office - I don't know your application, so I can't say for certain, but your comments certainly imply that it doesn't I would suggest unchecking it on your machine and saving your file. I know for certain it isn't a standard library need to run office. It isn't on any version of Excel I use. -- Regards, Tom Ogilvy "Ed" wrote: The missing file is apparently mergemod.dll in C:\Program Files\Common Files\Microsoft Shared\MSI Tools on my development machine, which seems to be running Excel 2002 SP3. There is no such file or directory on the 2nd machine which is running without any SPs. Ed "Ed" wrote in message ... You're right. It says that Microsoft MSM Merge Type library is missing. Wonder why? As I said, I did a repair of the installation off the Office 10 CD. Also, the test machine is my wife's, in a room across the hall. I'm a bit worried that it might fail on another machine a bit more difficult for me to get at and fix. Thanks to Tom and others who identified the problem. Ed "Tom Ogilvy" wrote in message ... on the problematic machine, after the error, go into tools=References in the VBE and you should see one or more references marked as MISSING. Fix these references as they are the source of your problem (high probability they have nothing to do with the string library). Or look in your own machine and see what references you have in this workbook that are not likely to be in your users environment. -- Regards, Tom Ogilvy |
#12
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can't find String functions.... Missing library
Tom,
I put that in at some point thinking it was necessary because I was launching Word and Mail Merge from Excel in a couple of my functions. From what you quote it seems it has nothing to do with ail Merge. I have unchecked it on my development machine and tested the functions that use MM. Seems to work OK. Tomorrow I'll test it on the other machine. Thanks. Ed "Tom Ogilvy" wrote in message ... this is from MSDN Merge Modules Merge modules provide a standard method by which developers deliver shared Windows Installer components and setup logic to their applications. Merge modules are used to deliver shared code, files, resources, registry entries, and setup logic to applications as a single compound file. Developers authoring new merge modules or using existing merge modules should follow the standard outlined in this section. . . . My guess would be that you don't need this and it has nothing to do with Office - I don't know your application, so I can't say for certain, but your comments certainly imply that it doesn't I would suggest unchecking it on your machine and saving your file. I know for certain it isn't a standard library need to run office. It isn't on any version of Excel I use. -- Regards, Tom Ogilvy "Ed" wrote: The missing file is apparently mergemod.dll in C:\Program Files\Common Files\Microsoft Shared\MSI Tools on my development machine, which seems to be running Excel 2002 SP3. There is no such file or directory on the 2nd machine which is running without any SPs. Ed "Ed" wrote in message ... You're right. It says that Microsoft MSM Merge Type library is missing. Wonder why? As I said, I did a repair of the installation off the Office 10 CD. Also, the test machine is my wife's, in a room across the hall. I'm a bit worried that it might fail on another machine a bit more difficult for me to get at and fix. Thanks to Tom and others who identified the problem. Ed "Tom Ogilvy" wrote in message ... on the problematic machine, after the error, go into tools=References in the VBE and you should see one or more references marked as MISSING. Fix these references as they are the source of your problem (high probability they have nothing to do with the string library). Or look in your own machine and see what references you have in this workbook that are not likely to be in your users environment. -- Regards, Tom Ogilvy |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
find string data type related functions | Excel Programming | |||
Compile Error: Can't find project or library (missing Add-in) | Excel Programming | |||
Dynamic Find and Replace String Within Functions Based on Column Values | Excel Programming | |||
Reference Library - Missing Library in a lower version. | Excel Programming | |||
Library missing.. | Excel Programming |