Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Importing / OLE DB Query
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Importing / OLE DB Query
N
For some reason, posts from excelforum don't thread properly in my newsreader. Posts that are replies to my post show up in red so that I don't miss them, but your post isn't a reply to mine, but to your original one. If you like to use excelforum instead of connecting directly to the MS servers, you should complain about that. In the mean time, if I don't reply to you it probably means I missed your post. I would appreciate any additional help you can offer. Just so you know, my skill level is probably between an Intermediate and Expert user of Excel. I understand the concept that you're explaining, but implementing it by myself would prove to be a very difficult task for me. I need some details. What does your data look like? How many colors do you use and what do they mean? What is unique about each record? Do records every fall off the report or are they on there forever? Are you refreshing an external data table that exists in the same workbook each time, or are you creating a new external data table in a new workbook? -- Dick Kusleika MVP - Excel Excel Blog - Daily Dose of Excel www.dicks-blog.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Importing Union Query | Excel Discussion (Misc queries) | |||
Importing access query | Excel Discussion (Misc queries) | |||
Importing Data via Web Query - Can values be passed to query? | Excel Discussion (Misc queries) | |||
Importing / OLE DB Query | Excel Programming | |||
Problem importing using MS Query | Excel Programming |