Natural starting point is Report PickList form. After selecting desirable time period and variable RefN (start and end) hitting EXL export button will open target Excel file which will incorporate exported data ...The transfer itself creates a new spreadsheet and uploads all data at once.
The VBA code which is doing the magic was taken from the cult book ACCESS 2000 written by Ken Getz, Paul Litwin and Mike Gilbert.
In this way the collected data can easily be used by third party application ...
