Transport Canada
...
Data Extract Procedure
Kurt Martin - 2021-08-03
PBI #112722 - produce monthly report
PBI #172651 - add this report to the CAWIS menu
######################
...
Execute this code – SEE ATTACHMENT
Please note : this code will always extract Y05 log data for the PREVIOUS month, for the Current reporting year (where reporting-year = current-year -1)
Step 4 –
Export the data to a text file. Import that text file to the new spreadsheet, save a copy to the archive (where you got the original xlsx) and email this month's report to Eric Lanthier .
...