Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
sinnetBS
 
Posts: n/a
Default automate importing text files?


Greetings,
First of all, my apologies - I know similar questions have been posted,
but I'm new to complex Macros (have read some of the beginner's sites
recommended here, will continue to do so) and am not yet able to figure
out how to do what I need based on other posts.

I have a bunc of delimited text files that were created from Word
survey forms (I had word "save data only for forms").

I know I can pull each one of these files individually into excel using
the import command. Is there a way to automate this so i don't go
through the same process each time? In other words, can i just do One
import command instead of importing each file individually? Or I guess
a different way would be, can i pre-combine each text file in such a
way that when that one combined file would be imported, excel would
know to start a new row at x point, etc? I think the first option would
be better, but if it's not possible, ideas on the second are welcome.

Thanks so much!


--
sinnetBS
------------------------------------------------------------------------
sinnetBS's Profile: http://www.excelforum.com/member.php...o&userid=35693
View this thread: http://www.excelforum.com/showthread...hreadid=554784

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
Need Help Importing Text File Using Two or More Spaces as the Delimiter [email protected] Excel Discussion (Misc queries) 11 June 13th 06 02:08 AM
Help extract numerous text files and how to use avg formula [email protected] Excel Worksheet Functions 0 May 16th 06 11:38 PM
How do I import several text files into excel or access ? acechef11 Excel Discussion (Misc queries) 2 June 9th 05 08:12 PM
Help importing text files into individual cells saybut Excel Discussion (Misc queries) 4 May 31st 05 03:24 PM
Importing text files into Excel Christopher Anderson Excel Discussion (Misc queries) 2 December 4th 04 05:57 PM


All times are GMT +1. The time now is 01:16 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"