To explain a little better what I need this for as its pretty different.
Basically we run a live broadcast, and I essentially need someone answering phones and entering details of the phone callers into an XLS spreedsheet.
Each time they update the sheet with some new caller details, i'd like them to be able to run a macro, which then saves that XLS as a CSV file.
This CSV can then be read, by our broadcast equipment, reading out information to put caller details on screen.

What i've noticed is that if you do saveas csv, it will shut your XLS document, and open the CSV its saving to.
I cant have the CSV open, otherwise our broadcast equipment cant open the file. So i'm trying to have the CSV shut the moment its opened, and the original XLS reopened. Ready for that macro to be pressed again, after more data is changed and the process repeats.

I'm running Mac Office 2011

Any help is most appreciated!