Match and Retrieve Values

  • Thread starter Thread starter Todd Huttenstine
  • Start date Start date
T

Todd Huttenstine

hey guys

Lets say I have data in workbook "RV.xls" worksheet "test"
Range "A3:A100". The workbook is closed and I do not want
to open it. What is the code that will make it look for
the value "TestVal23" in that sheet and if it finds it, it
then returns either True or False? And also if it finds
it, how do I make it return the cell address where it
found it?


Thanks
Todd Huttenstine
 
The short answer to your question is "Use Office Automation". The long
answer is too long to go into here - if you are not used to using VBA
from Access to control Excel, you need to learn the basics of
Automation before you try to do this sort of thing. If you are, you
almost certainly would not be asking this question.

hey guys

Lets say I have data in workbook "RV.xls" worksheet "test"
Range "A3:A100". The workbook is closed and I do not want
to open it. What is the code that will make it look for
the value "TestVal23" in that sheet and if it finds it, it
then returns either True or False? And also if it finds
it, how do I make it return the cell address where it
found it?


Thanks
Todd Huttenstine
Click to expand...


Please respond to the Newsgroup, so that others may benefit from the exchange.
Peter R. Fletcher
 
Back
Top