Need to import by font color criteria

[Crystal]

Hello,

Any suggestions would be greatly appreciated! I cannot
change how the customer sends me the data so that is not a
possibility (much as I'd like it to be).

I have a form that uses code to import spreadsheets that
we receive from our customer. The spreadsheets contain
changes, additions, deletions to items we track for them
I have code that updates the tables in the database based
upon the type of change.

The only step in all of this that we have human error is
cleaning up the spreadsheet for importing. The customer
puts all of their "changes" in red font. I need to be
able to only import the text that is in red into a table I
use for processing. Is it possible to add to the code a
way to distinguish between the different colors of text
when importing from Excel?

Thanks!

 

[Larry Daugherty]

Yes.

You need to establish a reference to Excel so that you can use Excel to
examine the color of the text. Of course, you'll have to open one of the
spreadsheets interactively in Excel to find what color values they are
using. Once you know that you can branch in your VBA code depending on the
color.

hth

 

[Crystal]

Larry,

Thanks for the assistance with both of my import
questions. The color value is always the same. I'll only
need to import those cells that contain any red text. My
queries simply update the entire field in Access with the
updated info IF that cell in Excel contains red text.
I'll have to research your suggestion on how to use Excel
to reference the color of the text. Thanks!