JohnAtWork
Mar 29th, 2000, 04:31 AM
I'm coding some stuff in Access using Excel's COM.
Specifically, I'm in an Excel application in order to grab a recordcount for some arrays, blah blah blah
The kicker is this:
I'm trying to use Excel's Find method on a Range Object.
No problems, except I get syntax errors whenever I try and do it due to the Find method that Access uses.
Is there any way I can Disambiguate my method in order to tell VB that I want to use Excel's Find Method?
Or should it work by default since the Expression is a Range object?
argh.
Specifically, I'm in an Excel application in order to grab a recordcount for some arrays, blah blah blah
The kicker is this:
I'm trying to use Excel's Find method on a Range Object.
No problems, except I get syntax errors whenever I try and do it due to the Find method that Access uses.
Is there any way I can Disambiguate my method in order to tell VB that I want to use Excel's Find Method?
Or should it work by default since the Expression is a Range object?
argh.