Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 57
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2,836
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 57
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Pulling pdf files from general folder to specific folder [email protected] Excel Discussion (Misc queries) 2 September 8th 09 09:41 PM
User selection of folder and open all .xls files within folder Barb Reinhardt Excel Programming 4 April 14th 07 01:41 PM
Need to Export All Worksheets from All Workbooks in Folder to Separate FIles not as CSV Files socrtwo Excel Programming 2 October 30th 06 01:46 AM
how can I specific a folder with wildcard criteria and excel will import all the correct files in that folder? Raven Excel Discussion (Misc queries) 1 January 24th 06 04:28 PM
how can I specific a folder with wildcard criteria and excel will import all the correct files in that folder? Raven[_2_] Excel Programming 1 January 24th 06 05:23 AM


All times are GMT +1. The time now is 06:48 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"