Please help - Spreadsheet find function on the access form fails

D

Dhananjay

Hello all!!
I am having office 2003 on my machine.
I have developed one access form on which I am having OWC11 control
(spreadsheet). When I fired my query to find "*", it fails. My code
snippet is as follows ---

set ctrl=me!("Spreadsheet0") ' it is the spreadsheet control viz.
Microsoft Office Spreadsheet 11.0
set rng=ctrl.activecell.entirecolumn.find("*") ' <---- Here is the
problem

Here rng is always sets to "Nothing" though spreadsheet is having any
data in it. Where m i wrong? because if I fire the same query in
excel-vba it works fine.
Please point me to right direction.

Any help would be really great for me.

Thanks,
Dhananjay
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top