View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jim Rech Jim Rech is offline
external usenet poster
 
Posts: 2,718
Default Excel SaveAs not using specified FileFormat

Try using 21 instead of xlTextMSDOS.

--
Jim
"NancyTG" wrote in message
...
| I'm using Excel as an ActiveX object and trying to use the SaveAs method
in
| Excel to programmatically save the workbook in different file types. The
| file saves (has an updated date & time stamp) but not in the specified
| format. Instead it is always in the Excel format. I'm using the
FileFormat
| parameter with a value of , e.g., xlTextMSDOS. Is there something else
that
| needs to be specified, also. All help is much appreciated! Nancy