Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
reference missing?
someone just described the following problem to me. I'm wondering if anyone
has seen this before and knows how to fix? An excel (not sure which version) file which uses some VBA code was running happily on a windows98 machine. The machine was upgraded from windows98 to windows2000. Now the file gets an error about not being able to find one of those library files referenced? not sure wich one, as I said the problem was described to me so I can't look again or get more details. When looking at the references she said it displayed it was looking for it under c:\windows\system32\.. There is no 'windows' directory in windows2000, its c:\winnt\system32 by default. She said she created a c:\windows\system32 directory and copied the file it was looking for there but that did not help. The error referenced the Trim() function... so its the library that that is from. any ideas? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
reference missing?
After you experience the error
go into the VBE make this workbook the active project before you do that (not activeworkbook in excel, but the active project in the vBE) Then from the menu select Tools = References in tools=references you should see at least on reference shown as MISSING unselect it if not needed or click on it and use the browse button to find it in win 2000 (go to the Winnt hierarchy - don't go to the copy she made). -- Regards, Tom Ogilvy "djc" wrote in message ... someone just described the following problem to me. I'm wondering if anyone has seen this before and knows how to fix? An excel (not sure which version) file which uses some VBA code was running happily on a windows98 machine. The machine was upgraded from windows98 to windows2000. Now the file gets an error about not being able to find one of those library files referenced? not sure wich one, as I said the problem was described to me so I can't look again or get more details. When looking at the references she said it displayed it was looking for it under c:\windows\system32\.. There is no 'windows' directory in windows2000, its c:\winnt\system32 by default. She said she created a c:\windows\system32 directory and copied the file it was looking for there but that did not help. The error referenced the Trim() function... so its the library that that is from. any ideas? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I delete a missing reference to a Macro | Excel Discussion (Misc queries) | |||
INDEX - MATCH - VLOOKUP - returning missing reference | Excel Discussion (Misc queries) | |||
A missing reference, maybe? | Excel Worksheet Functions | |||
Missing Reference in Excel 2003 | Excel Discussion (Misc queries) | |||
Missing Reference | Excel Programming |