Does anyone know of a way to automatically run a macro when I open a CSV
file in Excel.
I know how to use run a macro when I open an excel file, but this won't
work for CSV's.
I know i could just create a macro and press a key once the csv is open
but would like to know if this could be automated all together.

Is there a way to re-programme the file open option for CSV's ?