Macro to Save current XLS, then to save as a CSV. Then close CSV and reopen XLS

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!

Took a look, but not sure how it helps?

I have a feeling I have partially solved it.

I tell the macro to open the CSV first, copy paste the cells, then close the CSV. This seems to work. The only step the macros gets hung on is when you go to close a CSV it asks if you really want to save to this format? I dont know how to automate the press "yes" button.

Any ideas on that?