Can you send me the workbook. I would like to play with it.



if it is too sensitive, then never mind.

Also, what version of Excel are you using?

--
Regards,
Tom Ogilvy

John Wilson wrote in message
...
Tom,

run Rob Bovey's code cleaner on the file
I use Rob's Code Cleaner religiously on a lot of my workbooks.
Tried it again with this one, just to be sure, and I still get the
compile error.

It's just strange that for years I've never had to preface any
of these and then one day, all of a sudden, I do.

Of course, if I could retrace my steps that fateful day, I'd know
because I'm certain it's something that I did or some program
that I loaded that cased it.

Oh well, I'll just have to religiously use the preface from now on.
Can't hurt.

Thanks again,
John

"Tom Ogilvy" wrote in message
...
Just for fun, run Rob Bovey's code cleaner on the file and see if it
clears
up.

http://www.appspro.com

--
Regards,
Tom Ogilvy

John Wilson wrote in message
...
Dennis,

I have run into that very problem myself
Was wondering if I was the only one that experienced this problem.

The most rational explanation advanced was that Excel may be
trying to extract the Left( )
and similar functions that may be contained in one of the other
object
libraries listed under Tools-References, which is why writing
VBA.Left( )
gets
you to the proper one.
That does make sense.

changing Left( ) to VBA.Left( ),
and similarly with Chr( ), Mid( ), Right( ), Date, Space( ), etc.
Did that already on all my workbooks.

Still at a loss as to why it suddenly became a requirement???
Obviously, something that I (and yourself) did, but what??
I have no clue.

Thanks for the explanation,
John

"DennisE" wrote in message
...
John,

I have run into that very problem myself
from time to time as I installed Excel software with extensive VBA
macros
on various computers. Tools-References
never showed any references as missing,
and code checking for a broken link
never revealed one either (see page 512
of Excel 2002 VBA by Bullen et al for the
technique). What invariable fixed the problem was doing a reinstall
of
Office
and if that didn't work of both Office and
the Windows operating system. (This did not win me friends, however,
because of
the down-time required to effect this.)

When I read your message to the forum, I did a search of the MS
Knowledge
Base
and found nothing on the topic there. But when I did a search on
Google
with
keyword VBA.Left found several articles
on the subject. The most rational explanation advanced was that
Excel
may
be
trying to extract the Left( )
and similar functions that may be contained in one of the other
object
libraries listed under Tools-References, which is why writing
VBA.Left( )
gets
you to the proper one. Now that i know this, I will do a search and
replace of
all built-in functions in my Excel programs, changing Left( ) to
VBA.Left( ),
and similarly with Chr( ), Mid( ), Right( ), Date, Space( ), etc.

-- Dennis Eisen