tables

Tech-Archive recommends: Speed Up your PC by fixing your registry

Hi, Ive built an application that gets live data every 5 secs and
sends it to excel. In excel Ive got 4 small tables (9x9), which I use
vba to sort the data and allocate to the correct table. This works
well, infact Im chuffed Ive managed to do this. The next stage is to
bypass excel altogether and have the data within the application
itself. Only I cant figure the best way to do it. Any ideas
appreciated. So far Ive thought of maybe 4 datagrids, the data bieng
saved on closing. Its important that I retain prev data. Or save the
data in a file, read this file into 4 arrays, work and update data
during session, then save data back to file on closing, or
periodically. Finnally a database os some sort.
Regards Robert

.

Relevant Pages

  • Re: SORTING question
    ... I'm just going to pass along some general (Excel) sorting advice. ... When you tell Excel to sort, you can do so in several ways. ... > about having the original order disrupted because occasionally I will have ...
    (microsoft.public.excel.newusers)
  • Re: Sorting
    ... Wouldn't it be easier to use a software package like Family Tree Maker ... Why do you think you can make Excel sort in a different manner ... you certainly cannot use Excel alone to sort your data. ... need a macro to sort each column twice by creating a text string ...
    (microsoft.public.excel.programming)
  • RE: Sorting Alphanumeric data in Excel 2003
    ... Do you mean that you can sort the data as you expected in Excel 2000/2002? ... Microsoft Online Partner Support ... | cell format is also copied when you copy/paste in Excel. ...
    (microsoft.public.excel.setup)
  • Re: Update Query to Overwrite Old Data Automatically
    ... Rather than trying to update the Excel ... Spreadsheet, why don't you just provide them a new spreadsheet each month? ... Is this some sort of web based database application? ... The database does already have a last updated field. ...
    (microsoft.public.access.queries)
  • Re: Automatic Sorting?
    ... LOOKUP functions but finds the value based upon a row and column index ... >>> Is there a way that Excel can automatically sort a> column? ... >>> Scott B. Hogle ...
    (microsoft.public.excel.programming)