Hi All

I am trying to write some VBA that will export one sheet from m
workbook as a CVF file. I can do this using:

ActiveWorkbook.SaveAs myFileName, xlCSV

...but this leaves me with the open document pointed at the new CS
file on disk. In an attempt to work around this, I tried storing th
original path first and saving back to that location as a standar
Excel workbook. This works, except the sheet I exported to CSV is no
renamed (great 'feature'), thus breaking my macro!

Does anyone know of a cleaner way to do this (short of writing my ow
CSV generator, which seems a little excessive)? The existence of th
'Excel 2000 Programmatic Text Export Update
(http://office.microsoft.com/Download.../xl8p8pkg.aspx) on the M
Office site would seem to suggest that there might be a sensibl
programmatic interface to the export filters somewhere, but I can'
find it..

--
lucid
-----------------------------------------------------------------------
lucidr's Profile: http://www.excelforum.com/member.php...fo&userid=3669
View this thread: http://www.excelforum.com/showthread.php?threadid=56433