Execute the code provided, and export the results to C:\data\aair\data.txt
...
from the CAWIS reports directory at:
\\ncrfs345\GROUPS\AARD\AARD Public\CAWIS-REPORTS
...
Rename the file AAIRDATA-(current-date).XLXS
where current-date = today's date.
Open the file, highlight and delete the old data, now the cells are mostly pre-defined in the way we want them. Notice that Tab-2 contains all the data definitions and descriptions.
Import DATA.TXT into Tab-1 of AAIRDATA-(current-date).XLXS, taking care to define each date & long-numeric field as TEXT, since EXCEL has a tendency to convert these over to scientific notation.
...
Click SAVE and copy the new file back to
\\ncrfs345\GROUPS\AARD\AARD Public\CAWIS-REPORTS
...