If the workbook is a CSV, then savecopyAs saves a copy as CSV.

--
Regards,
Tom Ogilvy

"gloryofbach"
wrote in message
...

Hello Kaak,

Thank you very much for your considered reply - funny enough your
method is the exact same way I am doing it. My issue is that I am
saving the data.csv every 20 seconds for 8 hours a day (the process
runs on a timer to ensure data.csv is always up to date). In this sense
the method seems rather inelegant, as you are having to create a new
workbook each time etc and the temporary workbook number is Book1
etc... by the end of the day it will be book1500 etc...

This isnt a big deal but I am surprised you cannot use savecopyas
function to save a sheet as a csv file!

Is my understanding correct?

Alex


--
gloryofbach
------------------------------------------------------------------------
gloryofbach's Profile:
http://www.excelforum.com/member.php...o&userid=28322
View this thread: http://www.excelforum.com/showthread...hreadid=480090