Restart Excel, which will load the hidden workbook containing the CSV macro you just wrote. Open any existing workbook with data on more than one worksheet, then press "Alt-F8" to display a list ...

Open Folder Options in the control panel. Go to the File Types tab, scroll down to Microsoft Excel Worksheet (.xls not .csv) and click Advanced.