?
Solved

Getting data from Excel

Posted on 2004-08-23
3
Medium Priority
?
168 Views
Last Modified: 2010-05-02
Hi,

From Visual Basic I need to open an Excel worksheet and retrieve all rows which either have a blue background or blue text. Now, I can open the worksheet but is there anyway to retirve the relevant rows rather than just looping through them all?

Thanks in advance,
Dan
0
Comment
Question by:zomby_dog
  • 2
3 Comments
 
LVL 8

Expert Comment

by:ampapa
ID: 11868993
No, I believe you will have to loop through each row to retrieve the desired information. this should work but hasn't beentested.

For i = 1 to activesheet.usedrange.rows.count
    if ActiveSheet.Rows(i).Font.ColorIndex = 5 or ActiveSheet.Rows(i).Interior.ColorIndex = 5 then
    ....
    "do something"
    end if
next i
0
 
LVL 7

Accepted Solution

by:
_agj_ earned 500 total points
ID: 11869633
just a suggestion....not possible at the moment to verify it..

use the .Find function to search in the entire sheet.

the find function can be used to say, search in Formulas of a sheet. I think u shud be able to search in the Fonts/COlors.

use the range returned by find() to get the rows.

more when i check this up.
0
 
LVL 7

Expert Comment

by:_agj_
ID: 11889436
can u send me the code snippet u used finally?
0

Featured Post

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

Question has a verified solution.

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

This article describes some techniques which will make your VBA or Visual Basic Classic code easier to understand and maintain, whether by you, your replacement, or another Experts-Exchange expert.
This article describes how to use a set of graphical playing cards to create a Draw Poker game in Excel or VB6.
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
Get people started with the process of using Access VBA to control Excel using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Excel. Using automation, an Access application can laun…
Suggested Courses
Course of the Month14 days, 23 hours left to enroll

840 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