Excel SaveAs not using specified FileFormat
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 |
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 |
Excel SaveAs not using specified FileFormat
I tried it, but still got an Excel file format. Thanks, Nancy
"Jim Rech" wrote: 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 |
All times are GMT +1. The time now is 08:31 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com