Importing Mutiple .txt files

		Wrox Programmer Forums > Microsoft Office > Excel VBA > Excel VBA
Importing Mutiple .txt files

Excel VBA Discuss using VBA for Excel programming.

Welcome to the p2p.wrox.com Forums.

You are currently viewing the Excel VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com

February 10th, 2014, 12:44 PM

ecotopia

Registered User

Join Date: Feb 2014

Posts: 1

Thanks: 0

Thanked 0 Times in 0 Posts

Importing Mutiple .txt files

Hi there, I need help for a automated program I'm trying to make:

I need to open 3 files in 3 different sheet. the content of the txt file is basically column with numbers except for the first row which is the name.

text 1 text 2 text 3
2 1 1
1 2 2
12 2 2
2 2 1
1 2 2
2 2 2
2 1 2

I would also like that the newly sheets created get rename to something of my choice ( essay1, essay2, essay3)

any help is grandly appreciated. thanks guys!

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Importing Fixed Width .txt Document and Then Some!	Diretemus	Access VBA	8	March 26th, 2008 07:27 AM
Importing date field in a large txt file	CongoGrey	Access	2	July 10th, 2007 06:44 AM
WHERE IS THE TXT FILES OF BOOK?	PedroPN	BOOK: Professional SQL Server 2005 Integration Services ISBN: 0-7645-8435-9	2	July 5th, 2007 10:32 AM
Importing txt file sorting and graph	Torbma	Beginning VB 6	0	May 17th, 2006 06:07 AM
Uploading txt files	arnabghosh	Classic ASP Basics	1	June 15th, 2005 04:44 PM