| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
coverting all *txt files in a folder to formatted .xls files
I have limited experience of macros and I am looking for some help to
automate the following process. I would like to take a number of *txt files in a folder and convert them into formatted .xls files in the same location, the delimeter in the files varies however. Can anyone help ? -- Adrian |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
coverting all *txt files in a folder to formatted .xls files
Look he http://www.rondebruin.nl/copy4.htm This is a batch processing macro. You will have to change the text in red to do what you actually want to do. HTH, Ryan--- -- Ryan--- If this information was helpful, please indicate this by clicking ''Yes''. "Adrian" wrote: I have limited experience of macros and I am looking for some help to automate the following process. I would like to take a number of *txt files in a folder and convert them into formatted .xls files in the same location, the delimeter in the files varies however. Can anyone help ? -- Adrian |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
coverting all *txt files in a folder to formatted .xls files
Thanks Ron but this doesn't do quiet what I had in mind I would like to take
all of the .txt files in a folder and convert them to formatted workbooks and save them back to the original source. The code you supplied probably could have done that but it was too far off for me to modify with my limited knowledge. -- Adrian "Adrian" wrote: I have limited experience of macros and I am looking for some help to automate the following process. I would like to take a number of *txt files in a folder and convert them into formatted .xls files in the same location, the delimeter in the files varies however. Can anyone help ? -- Adrian |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pulling pdf files from general folder to specific folder | Excel Discussion (Misc queries) | |||
| User selection of folder and open all .xls files within folder | Excel Programming | |||
| Need to Export All Worksheets from All Workbooks in Folder to Separate FIles not as CSV Files | Excel Programming | |||
| how can I specific a folder with wildcard criteria and excel will import all the correct files in that folder? | Excel Discussion (Misc queries) | |||
| how can I specific a folder with wildcard criteria and excel will import all the correct files in that folder? | Excel Programming | |||
Linear Mode
