| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Save File
I have a file that I want to save using VBA to a space delimited file with
double quote marks around each cell of data. I figured out how to save the file as an xls but I can not find anything on saving or exporting the data to a space delimited text file with double quotes around each cell of data. Does any one have any ideas? Thanks in advance for the help! Mike Charney m charney at dunlap hospital dot org (No spaces and change the characters) |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Save File
Take a look at how J.E. McGimpsey does it at:
http://mcgimpsey.com/excel/textfiles.html (Look for: CSV with quotation marks around each field) He actually uses a comma, but you could use a space character: sOut = sOut & "," &QSTR & _ would become: sOut = sOut & " " &QSTR & _ Mike wrote: I have a file that I want to save using VBA to a space delimited file with double quote marks around each cell of data. I figured out how to save the file as an xls but I can not find anything on saving or exporting the data to a space delimited text file with double quotes around each cell of data. Does any one have any ideas? Thanks in advance for the help! Mike Charney m charney at dunlap hospital dot org (No spaces and change the characters) -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Save File
That worked great thanks!!!
Mike Charney "Dave Peterson" wrote in message ... Take a look at how J.E. McGimpsey does it at: http://mcgimpsey.com/excel/textfiles.html (Look for: CSV with quotation marks around each field) He actually uses a comma, but you could use a space character: sOut = sOut & "," &QSTR & _ would become: sOut = sOut & " " &QSTR & _ Mike wrote: I have a file that I want to save using VBA to a space delimited file with double quote marks around each cell of data. I figured out how to save the file as an xls but I can not find anything on saving or exporting the data to a space delimited text file with double quotes around each cell of data. Does any one have any ideas? Thanks in advance for the help! Mike Charney m charney at dunlap hospital dot org (No spaces and change the characters) -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| SAVE and SAVE AS options disappeared from the drop down FILE menu | Excel Discussion (Misc queries) | |||
| Excell2003 (SP-1) File > Save and File > Save As.. grayed out | Excel Discussion (Misc queries) | |||
| Save Excel file - prompts to save - no Volitile functions used | Excel Worksheet Functions | |||
| Excel marcos firing on file save as but not file save | Excel Programming | |||
| Save File to Another Directory, but not change Users File Save location | Excel Programming | |||
![Mike[_97_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
