Basics of situation:
Download from Bank Account creates CSV file,
Upload to Accounting system requires CSV but with different layout to Bank file.
I have got most of the process sorted but coming across issues.
1) Import CSV data
2) Re-arrange layout
3) Export to CSV
Step 1 is where I am having issues.
Option 1 - I set it so that the Workings file would open the CSV file, select all and then copy into working file. This worked except when it came to dates. I am in UK so have date format dd/mm/yyyy but when I copy 10/04/2015 (10 April 2015) from the CSV and paste it into the working file it gets converted to 04/10/2015 (4 October 2015). Tried with making destination cell text or general format and neither worked. Dates such as 14/04/2015 (14 April 2015) gets pasted as text so stays OK.
Option 2 - I have tried to set up a Data Connection to the CSV file. I have set this so that the Date column comes in as text and that works fine but I then want to break the connection to the source file. I have tried recording the Connection break routine but when I include it in
the script it errors out.
Files attached with obfuscated data.
Any help greatly appreciated.
PS I am going to be offline for a few days after this afternoon so apologise if I don't respond to queries promptly.