This is not to say you CAN'T write stuff out to Excel... just that the code for that is a bit more complicated.
What you can do is create an Excel spreadsheet that reads CSV data in as a data source (not opening it as a file). You can then have the static Excel file with all your conditional formatting, etc., with your data source being written out to CSV.
Thanks for the reply... :smileyvery-happy:
So I have created a CSV file and managed to import it to an excel spreadsheet, however it doesn't seem to update every time I write to the CSV file. Is there a way to do this without importing the results again.
Cheers
