ole - excell saveas

[MikeL91]

How do I cange my ole saveas to save as type MAC csv?

this saves as excell

oleApp = CREATEOBJECT("Excel.Application&quot
oleApp.Visible=.T.
oleApp.WorkBooks.Open("S:\State.Xls&quot
oleApp.ActiveWorkbook.SaveAs((cpath)+"state.XLS&quot
oleApp.Quit


thanks in advance,
Mike

 

[Mike Gagnon]

Try:

MyExcel.SaveAs.FileFormat= 22 && xlCSVMac Mike Gagnon

 

[MikeL91]

Thanks mike,
I tried that, but it says "object "MyExcel" is not found.

I copied the text, but am not sure how to pass the filename to it. here is what I used:

oleApp = CREATEOBJECT("Excel.Application&quot
oleApp.Visible=.F.
oleApp.WorkBooks.Open("c:\MACBarcode\Temp.csv&quot
MyExcel.SaveAs.FileFormat=22 &&xlcsMac

I have to open a csv file i save from my foxpro table, so I create a file called temp.csv (my table saved type delim)

not too familiar with ole, obviously.

thanks for your help
-Mike

 

[baltman]

You have to use the correct name...

oleApp.WorkBooks.Open("c:\MACBarcode\Temp.csv&quot
oleApp.SaveAs.FileFormat=22

 

[danceman]

if you pln on doing more OLE programming I suggest that you look at faq184-2215 Attitude is Everything