Hi Naomi
Sounded right when you wrote it but the macro does not translate very well into vfp language. Below was full macro info - i did try and remove some of it without sucess. Can i try your code when you have some time?
thanks
k
procedure convert
oExcel = Createobject("Excel.Application")
If Vartype(oExcel) != "O"
Return .F.
Endif
oWorkbook = oExcel.Application.Workbooks.Open ("C:\mydirectory\myfile.xls")
oExcel.Visible = .T.
oExcel.Application.UserControl=.T.
oExcel.Application.Interactive=.T.
ChDir "C:\mydirectory\"
ActiveWorkbook.SaveAs Filename:="C:\mydirectory\admits.csv", FileFormat:= _
xlCSVMSDOS, CreateBackup:=False
ChDir "C:\vfp\"