2 Questions about code with excel 97
 

Hi Tom, you are right, there is a reference missing in the project. Bu
for some reason I am unable to delete it because it says that th
ressource is currently in use. What do you mean by resetting th
project? Do you mean start it over again? I tried to copy sheets fro
this project to a new one but for some reason it wont let me do it. A
I right click on the folder of the sheet 'sorry i don't know how to sa
this in english' the option 'move or copy' is grey and I cannot choos
it.

The whole story is that a guy in my company gave me this excel projec
that was already made by him. He ask me to change things in the projec
but the project seems to be corrupted already in the references... H
connected this excel file to another file on his computer. What h
would like to do is, no matter where this other file is located, tha
the connection still work... Yeah right so im coding some code to fin
the file on all available drives on the computer. But it's hard to d
cause I need to use functions such as : mid, left, right etc which
can't use right now due to references problems.

By the way the missing ressource is:
'Fincalc OLE Custom Control Module'

Awating your news. Thanks a lot!


Tom Ogilvy Wrote:
for you first problem, after it occurs, reset the project, then go into
Tools=References in the VBE and you should see at least one or mor
entries
Marked as MISSING. You need to clean up these references as they ar
the
source of the problem.

--
Regards,
Tom Ogilv

--
Rubican
-----------------------------------------------------------------------
Rubicant's Profile: http://www.excelforum.com/member.php...fo&userid=1641
View this thread: http://www.excelforum.com/showthread.php?threadid=27789