I have a program in VB5 that logs data once a minute to a spreadsheet.
I would like to archive it to Jet once a day
The workbook name is "Today.xls"
The sheetname is format$(now, "mmm dd yyyy")
Row 2 holds the 00:01 readings
Row 62 holds the 01:01 readings and so on to Row 1441
At midnight the last history worksheet is moved in front of worksheets(1) and the sheet I want becomes worksheets(2)
My declares are:
Dim m_App As New Excel.Application
Dim m_WB As Workbook ''Active Workbook for this excel instance
Dim m_WS As Worksheet "Active Worksheet
const WBfileName = App.Path + "\WB\Today.xls"
I always store string data in columns A - J. If the channel for that column isn't being used I stuff a default string and set the colwidth to 0.
Row 1 is always a heading row for the A-J columns
The row number is always (the minutes passed in the day) + 1
The sheetname is always the date.
I know nothing about Jet or Access.
How can I create and maintain a database that will let me compare strings from any 2 dates in its history?
Can someone provide a starter routine or give me link that gets me on top of it.