<big>Edited by HansV to break ridiculously long line. Please show SOME consideration for others!</big>
Working closely with my other post about renaming and moving of image files, I need to achieve the following.
I have a query that exports the required information to a txt file in the right format. This is fine so far. However it needs to be more complex than a standard exported text file.
The file needs to be be split into the following:
Version : 3 (fixed value)
EOF : '^' (fixed value)
EOR : '~'
Property Count : 'x' (total amount of records contained with the the query)
Generated Date : dd-mmm-yyyy hh:mm (Date stamp the file is generated)
Result of the query are placed here and if possible a line space between each record
The file needs to be a text file, but with the extension of BLT / BLM
Is there a way of compiling this with vba?