Solved

VS 2005 Tools for Office Find error

Posted on 2007-11-14
3
154 Views
Last Modified: 2013-11-26
Hi

I am getting an error on xlNext in the following code
rFound = oWb.Range(Detail).Find(oWhat, rngFoundInst, oLookin, oLookat, oSearchOrder, xlNext, False, False)
0
Comment
Question by:murbro
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 47

Expert Comment

by:Wayne Taylor (webtubbs)
ID: 20278686
What's the error? I can see a number of things that could be the problem, but then again, they may not.
0
 

Author Comment

by:murbro
ID: 20278742
xlNext not declared
0
 
LVL 47

Accepted Solution

by:
Wayne Taylor (webtubbs) earned 500 total points
ID: 20278763
Try either of these....

rFound = oWb.Range(Detail).Find(oWhat, rngFoundInst, oLookin, oLookat, oSearchOrder, Excel.XlSearchDirection.xlNext, False, False)

rFound = oWb.Range(Detail).Find(oWhat, rngFoundInst, oLookin, oLookat, oSearchOrder, 1, False, False)
0

Featured Post

MIM Survival Guide for Service Desk Managers

Major incidents can send mastered service desk processes into disorder. Systems and tools produce the data needed to resolve these incidents, but your challenge is getting that information to the right people fast. Check out the Survival Guide and begin bringing order to chaos.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A basic question.. “What is the Garbage Collector?” The usual answer given back: “Garbage collector is a background thread run by the CLR for freeing up the memory space used by the objects which are no longer used by the program.” I wondered …
Real-time is more about the business, not the technology. In day-to-day life, to make real-time decisions like buying or investing, business needs the latest information(e.g. Gold Rate/Stock Rate). Unlike traditional days, you need not wait for a fe…
Michael from AdRem Software outlines event notifications and Automatic Corrective Actions in network monitoring. Automatic Corrective Actions are scripts, which can automatically run upon discovery of a certain undesirable condition in your network.…
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…

728 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question