I am trying to do some stuff with excel automation.
What I have to do is Saveas an excel file in a CSV format and pass the data line by line via socket connection to a client.
My problem is when I SaveAs an excel file into a csv file and try to close excel and Quit it always asks me to save the file. I do not want this prompt as I will be running this from a DLL and this could hang the DLL. the reason why this happens is sine I am saving the file in a different format.
Is there a way to overide or forcefullt save the file. I have tried calling Save immediately after but the message box still comes up.
Any help on this would be appreciated.

Thanks in advance