Transaction download activity summary / log (like a syslog)

Microsoft Excel
1

hello Tiller Friends
i would like to ask if anyone has developed (VBA or few formulas) a process that summarizes what was downloaded each time we download transactions to the workbook??

like:

  1. Date / time
  2. number of transaction downloaded (total)
  3. number of balances downloaded (total)

would love to know

1 Like
2

@michaelo this can be very handy information! I would also be curious to know if someone has come up with such a solution

3

i wrote a piece of VBA code that does that. works great. it runs every time i close the workbook and records the date, time, # of transactions downloaded and # of balance history records downloaded
code:

Sub writesyslog()
Dim SysLogWS, TransactionsWS, BalanceHistoryWS As Worksheet
Dim syslogtbl, TransactionsTbl, BalsnceHistoryTbl As ListObject

Dim newRow As ListRow
Dim lastRowIndex As Long
Dim currentDateTime As Date

Set SysLogWS = ThisWorkbook.Sheets(“SysLog”)
Set syslogtbl = SysLogWS.ListObjects(“SysLogTbl”)

Set TransactionsWS = ThisWorkbook.Sheets(“Transactions”)
Set TransactionsTbl = TransactionsWS.ListObjects(“Transactions”)

Set BalanceHistoryWS = ThisWorkbook.Sheets(“Balance History”)
Set BalsnceHistoryTbl = BalanceHistoryWS.ListObjects(“BalanceHistory”)

'get the data
currentDateTime = Now
lastTransRowIndex = TransactionsTbl.ListRows.Count
lastBalanceHistRowIndex = BalsnceHistoryTbl.ListRows.Count

'write the data
Set newRow = syslogtbl.ListRows.Add
newRow.Range(1, 1).Value = Now
newRow.Range(1, 2).Value = lastTransRowIndex
newRow.Range(1, 3).Value = lastBalanceHistRowIndex

End Sub

2 Likes
4

How neat! Thanks for putting that together and sharing