worksheet_function

[Anamarie]

Hello and thanks for your advise:
I'm using Windows XP Office 2K
When I try to use any worksheet_function gives me a
window error:
"Undefined function NAME in expression"

How can I use those functions?
Thanks again
Anamarie

 

[Michel Walsh]

Hi,


Access has no "worksheet_" functions. Are you using Excel VBA functions
inside Access? Most won't work directly, even if you add the reference to
Excel, since there is no default Excel globally instantiated object in the
first place... you would have, probably, to open an Excel object and, from
there, use automation to make your Excel related functions to work. That is
NOT usual. WHAT are you trying to do (rather than HOW you are trying to do
it)?


Vanderghast, Access MVP