Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to open *.dat files and save as .txt (comma delimited text files)
Hi,
Would appreciate if someone would enlighten me on how I can accomplish the following: 1. Open each of the dat files in a directory in excel. These dat files are semicolon delimited files. 2. Apply a set of actions to the opened files (which I've already saved), then save the files as the original name except for a different extension. i.e. .txt (comma delimited files). 3. How do I convert *001 in a field to display 001 instead of 1? Seems like Excel will autoconvert the format to number instead of text. 4. How do I remove the trailing spaces after a name without impacting the spaces within a name? For e.g. "Harry Lee " becomes "Harry Lee". Thanks in advance for any help rendered. YW |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro that stores all sheets as tab-delimited text files | Excel Discussion (Misc queries) | |||
How do I turn off autoformat for .CSV (comma delimited) files? | Excel Discussion (Misc queries) | |||
how to save a file as ASCII: expanded comma delimited text (.exp). | Excel Discussion (Misc queries) | |||
Comma-delimited files and Reional Settings | Excel Programming | |||
Excel VBA-open & save all delimited files | Excel Programming |