|
FileFormat for "field1", "field2"
Hello
Which one of the file formats below in excel will save the records as "field1", "field2" including the quotation marks? xlAddIn xlCSV xlCSVMac xlCSVMSDOS xlCSVWindows xlCurrentPlatformText xlDBF2 xlDBF3 xlDBF4 xlDIF xlExcel2 xlExcel2FarEast xlExcel3 xlExcel4 xlExcel4Workbook xlExcel5 xlExcel7 xlExcel9795 xlHTML xlIntlAddIn xlIntlMacro xlSYLK xlTemplate xlTextMac xlTextMSDOS xlTextPrinter xlTextWindows xlUnicodeText xlWJ2WD1 xlWK1 xlWK1ALL xlWK1FMT xlWK3 xlWK4 xlWK3FM3 xlWKS xlWorkbookNormal xlWorks2FarEast xlWQ1 xlWJ3 xlWJ3FJ3 |
FileFormat for "field1", "field2"
None do that. You would need to write a macro to do it. Here is a good
start: http://support.microsoft.com/default...83&Product=xlw Procedure to Export Text File with Comma AND Quote Delimiter -- Regards, Tom Ogilvy "ww" wrote in message om... Hello Which one of the file formats below in excel will save the records as "field1", "field2" including the quotation marks? xlAddIn xlCSV xlCSVMac xlCSVMSDOS xlCSVWindows xlCurrentPlatformText xlDBF2 xlDBF3 xlDBF4 xlDIF xlExcel2 xlExcel2FarEast xlExcel3 xlExcel4 xlExcel4Workbook xlExcel5 xlExcel7 xlExcel9795 xlHTML xlIntlAddIn xlIntlMacro xlSYLK xlTemplate xlTextMac xlTextMSDOS xlTextPrinter xlTextWindows xlUnicodeText xlWJ2WD1 xlWK1 xlWK1ALL xlWK1FMT xlWK3 xlWK4 xlWK3FM3 xlWKS xlWorkbookNormal xlWorks2FarEast xlWQ1 xlWJ3 xlWJ3FJ3 |
| All times are GMT +1. The time now is 05:48 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com