PDA

View Full Version : Mulitple importing of text files



stolie
11-04-2007, 07:56 PM
HI all

I have searched quite a bit and found the article "Import Notepad and workpad text files" --->all the www's (wont let me paste the link)

vbaexpress.com/kb/getarticle.php?kb_id=497#instr

Which works great for me, however, i need to be able to select more then one file at a time to import.

Any suggestions

Thanks

unmarkedhelicopter
11-05-2007, 02:23 AM
How many do you need ? (is it always the same number ? does it increase by 1 each month ? )
It it a folder full ?
What about click and drag ?
What have you tried ?

lucas
11-05-2007, 08:34 AM
This is the correct link from post #1
http://vbaexpress.com/kb/getarticle.php?kb_id=497

RonMcK
11-05-2007, 10:27 AM
Stolie,

Let's say that you have 5 files to import. Why not use the tool you found 5 times, pulling each file in, in turn?

What drives the requirement to suck them all up at one time? How do you want to designate the files? Enter a list of names? Select them all from a list? or. ... (fill in your choice).

Thanks,

Ron
Orlando, FL