Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
compile error with Mid() function
I'm running some code which worked on another pc.
I'm getting: Compile Error: Can't find project or library. on a Mid() function. There is a reference on the PC that works in the VBA references called "Ref Edit Control" On the PC that it is not woring on it says the "Missing: Ref Edit Control" it shows the path and file to the DLL but when try to browse to it it still shows missing. In Both cases Im running Excel 2003. In the case that works I'm using Windows XP and the case that doesn't In using Windows 2000. I'm Assuming Ref Edit Control Missing is causing the Mid() funciton to fail but am not sure. How do I get it to work?? -- CroceJC |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
compile error with Mid() function
Hi jc, in your VB editor, click Tools, References. When the dialog box comes
up, locate the dll and check the checkbox, click OK and then save. It should run after tthat. "jc" wrote: I'm running some code which worked on another pc. I'm getting: Compile Error: Can't find project or library. on a Mid() function. There is a reference on the PC that works in the VBA references called "Ref Edit Control" On the PC that it is not woring on it says the "Missing: Ref Edit Control" it shows the path and file to the DLL but when try to browse to it it still shows missing. In Both cases Im running Excel 2003. In the case that works I'm using Windows XP and the case that doesn't In using Windows 2000. I'm Assuming Ref Edit Control Missing is causing the Mid() funciton to fail but am not sure. How do I get it to work?? -- CroceJC |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
compile error with Mid() function
Just uncheck that reference.
-- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "jc" wrote in message ... I'm running some code which worked on another pc. I'm getting: Compile Error: Can't find project or library. on a Mid() function. There is a reference on the PC that works in the VBA references called "Ref Edit Control" On the PC that it is not woring on it says the "Missing: Ref Edit Control" it shows the path and file to the DLL but when try to browse to it it still shows missing. In Both cases Im running Excel 2003. In the case that works I'm using Windows XP and the case that doesn't In using Windows 2000. I'm Assuming Ref Edit Control Missing is causing the Mid() funciton to fail but am not sure. How do I get it to work?? -- CroceJC |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
compile error with Mid() function
I did that. The file is there but it says " missing in the reference line"
-- CroceJC "JLGWhiz" wrote: Hi jc, in your VB editor, click Tools, References. When the dialog box comes up, locate the dll and check the checkbox, click OK and then save. It should run after tthat. "jc" wrote: I'm running some code which worked on another pc. I'm getting: Compile Error: Can't find project or library. on a Mid() function. There is a reference on the PC that works in the VBA references called "Ref Edit Control" On the PC that it is not woring on it says the "Missing: Ref Edit Control" it shows the path and file to the DLL but when try to browse to it it still shows missing. In Both cases Im running Excel 2003. In the case that works I'm using Windows XP and the case that doesn't In using Windows 2000. I'm Assuming Ref Edit Control Missing is causing the Mid() funciton to fail but am not sure. How do I get it to work?? -- CroceJC |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
compile error with Mid() function
It appears that I need it to get the "Mid" funtion to work.
-- CroceJC "Bob Phillips" wrote: Just uncheck that reference. -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "jc" wrote in message ... I'm running some code which worked on another pc. I'm getting: Compile Error: Can't find project or library. on a Mid() function. There is a reference on the PC that works in the VBA references called "Ref Edit Control" On the PC that it is not woring on it says the "Missing: Ref Edit Control" it shows the path and file to the DLL but when try to browse to it it still shows missing. In Both cases Im running Excel 2003. In the case that works I'm using Windows XP and the case that doesn't In using Windows 2000. I'm Assuming Ref Edit Control Missing is causing the Mid() funciton to fail but am not sure. How do I get it to work?? -- CroceJC |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
compile error with Mid() function
You did what? Did you put a check mark in the check box next to it and then
click OK? If so, that should have straightened out your problem. Rick "jc" wrote in message ... I did that. The file is there but it says " missing in the reference line" -- CroceJC "JLGWhiz" wrote: Hi jc, in your VB editor, click Tools, References. When the dialog box comes up, locate the dll and check the checkbox, click OK and then save. It should run after tthat. "jc" wrote: I'm running some code which worked on another pc. I'm getting: Compile Error: Can't find project or library. on a Mid() function. There is a reference on the PC that works in the VBA references called "Ref Edit Control" On the PC that it is not woring on it says the "Missing: Ref Edit Control" it shows the path and file to the DLL but when try to browse to it it still shows missing. In Both cases Im running Excel 2003. In the case that works I'm using Windows XP and the case that doesn't In using Windows 2000. I'm Assuming Ref Edit Control Missing is causing the Mid() funciton to fail but am not sure. How do I get it to work?? -- CroceJC |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
compile error with Mid() function
No, you need it unchecked to get Mid to work.
-- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "jc" wrote in message ... It appears that I need it to get the "Mid" funtion to work. -- CroceJC "Bob Phillips" wrote: Just uncheck that reference. -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "jc" wrote in message ... I'm running some code which worked on another pc. I'm getting: Compile Error: Can't find project or library. on a Mid() function. There is a reference on the PC that works in the VBA references called "Ref Edit Control" On the PC that it is not woring on it says the "Missing: Ref Edit Control" it shows the path and file to the DLL but when try to browse to it it still shows missing. In Both cases Im running Excel 2003. In the case that works I'm using Windows XP and the case that doesn't In using Windows 2000. I'm Assuming Ref Edit Control Missing is causing the Mid() funciton to fail but am not sure. How do I get it to work?? -- CroceJC |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
compile error with Mid() function
On the computer where the code does work it is checked. It is not checked on
the computere where it doesn't work. but the references shows missing. previously on the computer that works now it did not work until I checked it and it stayed checked. -- CroceJC "Bob Phillips" wrote: No, you need it unchecked to get Mid to work. -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "jc" wrote in message ... It appears that I need it to get the "Mid" funtion to work. -- CroceJC "Bob Phillips" wrote: Just uncheck that reference. -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "jc" wrote in message ... I'm running some code which worked on another pc. I'm getting: Compile Error: Can't find project or library. on a Mid() function. There is a reference on the PC that works in the VBA references called "Ref Edit Control" On the PC that it is not woring on it says the "Missing: Ref Edit Control" it shows the path and file to the DLL but when try to browse to it it still shows missing. In Both cases Im running Excel 2003. In the case that works I'm using Windows XP and the case that doesn't In using Windows 2000. I'm Assuming Ref Edit Control Missing is causing the Mid() funciton to fail but am not sure. How do I get it to work?? -- CroceJC |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Compile error on VBA Function | Excel Programming | |||
mid function causes a compile error | Excel Programming | |||
mid function causes a compile error | Excel Programming | |||
Help With - Compile Error: Sub or Function Not Defined | Excel Programming | |||
compile error using Left() function | Excel Programming |