Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2000 VBA Help File
Why are there functions and methods lited in the VBA help file for Excel
2000 that seemingly will not work on Excel 2000? A few examples: Str LTrim RTrim Trim Chr The list goes on and on but these are a few of the ones that are irritating me right now. Or am I missing a seeting that allows them to work fine on my Excel 2002 but prevents them from running on Excel 2000? Every time it encounters one of these functions it says, "Can't find project or library." The worst part is when I run across a function described in an old book for Excel 97 VBA that will NOT work on Excel 2000 but does in 2002. What's the deal? I'm just beginning to learn here so please help a novice out. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2000 VBA Help File
This is generally caused by a missing reference in your project rather than
the fact that the functions are available (both Excel 2000 and Excel 2002 use VBA 6 - so they do work in both). In Excel 2000, go to Tools=References in the VBE and make sure you project is selected in the project window (one of the elements/components are highlighted). Then go to Tools=References and you should see one or more entries shown as MISSING. You need to unselect these if your project does not use them, or install them on that machine if it does. Generally, use as few references as possible and only those you need. -- Regards, Tom Ogilvy "Shawn Shuler" wrote in message ... Why are there functions and methods lited in the VBA help file for Excel 2000 that seemingly will not work on Excel 2000? A few examples: Str LTrim RTrim Trim Chr The list goes on and on but these are a few of the ones that are irritating me right now. Or am I missing a seeting that allows them to work fine on my Excel 2002 but prevents them from running on Excel 2000? Every time it encounters one of these functions it says, "Can't find project or library." The worst part is when I run across a function described in an old book for Excel 97 VBA that will NOT work on Excel 2000 but does in 2002. What's the deal? I'm just beginning to learn here so please help a novice out. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2000 VBA Help File
Shawn,
They're not broken, but something else is. What you describe is a typical symptom of "version flu": you save a file in a later version then try to open it in an earlier version, and the reference to Word 2002 can't be resolved because you have Word 2000 on your older machine. The typical cure for this disease is to go into the VBE and use Tools | References, then look for missing references and delete them, then add in subsitute references for those that have gone missing. HTH, Bernie MS Excel MVP "Shawn Shuler" wrote in message ... Why are there functions and methods lited in the VBA help file for Excel 2000 that seemingly will not work on Excel 2000? A few examples: Str LTrim RTrim Trim Chr The list goes on and on but these are a few of the ones that are irritating me right now. Or am I missing a seeting that allows them to work fine on my Excel 2002 but prevents them from running on Excel 2000? Every time it encounters one of these functions it says, "Can't find project or library." The worst part is when I run across a function described in an old book for Excel 97 VBA that will NOT work on Excel 2000 but does in 2002. What's the deal? I'm just beginning to learn here so please help a novice out. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2000 VBA Help File
Thanks for the help, guys. As I said I'm new to this and the true help for
novices is hard to come by. The documentation is weak and books skip a lot of the basic information. I can understand that they can't cover everything. I'll try checking the references. Thanks. "Bernie Deitrick" <deitbe @ consumer dot org wrote in message ... Shawn, They're not broken, but something else is. What you describe is a typical symptom of "version flu": you save a file in a later version then try to open it in an earlier version, and the reference to Word 2002 can't be resolved because you have Word 2000 on your older machine. The typical cure for this disease is to go into the VBE and use Tools | References, then look for missing references and delete them, then add in subsitute references for those that have gone missing. HTH, Bernie MS Excel MVP "Shawn Shuler" wrote in message ... Why are there functions and methods lited in the VBA help file for Excel 2000 that seemingly will not work on Excel 2000? A few examples: Str LTrim RTrim Trim Chr The list goes on and on but these are a few of the ones that are irritating me right now. Or am I missing a seeting that allows them to work fine on my Excel 2002 but prevents them from running on Excel 2000? Every time it encounters one of these functions it says, "Can't find project or library." The worst part is when I run across a function described in an old book for Excel 97 VBA that will NOT work on Excel 2000 but does in 2002. What's the deal? I'm just beginning to learn here so please help a novice out. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
convert email address file in Excel 2000 to Word file with commas | Excel Discussion (Misc queries) | |||
Excel 2000 file in use when opening xls file | Excel Discussion (Misc queries) | |||
Open 2000 file attachments in Excel 2000 | Excel Discussion (Misc queries) | |||
Hyperlink in Excel 2000 can't open bookmarked Word 2000 file | Excel Discussion (Misc queries) | |||
How do I stop Excel 2000 from saving file history from file that . | Excel Discussion (Misc queries) |