I would appreciate any additional help you can offer. Just so you know
my skill level is probably between an Intermediate and Expert user o
Excel. I understand the concept that you're explaining, bu
implementing it by myself would prove to be a very difficult task fo
me.
-N. Kippen
Dick Kusleika Wrote:
"nkippen" wrote in message
...
I don't know exactly to what forum I should be posting thi
question,
so I thought I'd start here with the gurus.
A fine choice. excel.querydao would have been okay too.
Is there away that I can import only the newly added accounts to my
copy of the excel document on my desktop, that way all the accounts
that I have color coded remain color coded and I can easily go down
through the list analyzing only the newly added accounts to th
excel
document that is updated weekly?
Or in other words is there a way to only import the newly added
accounts to my excel document without having to import the entire
document thus overwriting everything that I have done?
Is there some parameters I need to use in my Query options with the
Importing tool? Or will I have to come up with some Visual Basi
Macro
or something to be able to do this?
I don't think so. You can definitely import only new records, bu
that's
all that will be the new records. The old ones will be gone an
you
don't want that. I would probably make a separate table of previously
analyzed records using some kind of unique field to identify them and
code
to determine what color they should be. Then I would use VBA t
re-color
the rows after the query table was refreshed. In as separate fil
(an
excel file or even a text file) you could have information like
1001 Blue
1003 Red
1010 Blue
and the macro would read down this file and color the rows the wa
they
were. Another macro could update the file when you're done analyzin
the
new records to record their colors. You definitely need some way to
uniquely identify those records.
If this sounds like something you want to try and you need some help
implementing it, post back.
--
Dick Kusleika
MVP - Excel
Excel Blog - Daily Dose of Excel
www.dicks-blog.co
--
nkippe
-----------------------------------------------------------------------
nkippen's Profile:
http://www.excelforum.com/member.php...fo&userid=1548
View this thread:
http://www.excelforum.com/showthread.php?threadid=27061