Photo Gallery Member List Search Calendars FAQ Ticket List Log Out


Importing multiple .txt files into Excel.

  		Logged in as: Guest
arrSession:exec spGetSession 2,2,1403
Active Users: There are 0 members and 0 guests.
Users viewing this topic: none
 

 

  
 
  Printable Version
All Forums >> [Scripting] >> WSH & Client Side VBScript >> Importing multiple .txt files into Excel.
  Do you like VisualBasicScript.com? Link to us and help spread the word about our forum. Thanks! 		Page: [1]
Login
Message << Older Topic   Newer Topic >>
Importing multiple .txt files into Excel. - 9/28/2004 3:30:44 AM   
  keving

 

Posts: 2
Score: 0
Joined: 9/28/2004
From: USA
Status: offline 		I want to import about 50 .txt files into 1 excel document. Being that I am brand new to programming, I don't even nknow if this is possible with VBScript. Can someone help me!!!?

Thanks,

Keving
 
 
Post #: 1
 
Re: Importing multiple .txt files into Excel. - 9/28/2004 3:32:41 AM   
  mbouchard


Posts: 1916
Score: 16
Joined: 5/15/2003
From: USA
Status: offline 		How are the text files formated? How do you want them imported?

(in reply to keving)
 
 
Post #: 2
 
Re: Importing multiple .txt files into Excel. - 9/28/2004 6:36:30 AM   
  keving

 

Posts: 2
Score: 0
Joined: 9/28/2004
From: USA
Status: offline 		They are in notepad...... Each one of these files is a pricelist for a certain customer belonging to a certain Sales Rep. I need to get all 50 files into one file so I can e-mail it to the Rep. I want to import them the quickest and easiest way possible because I need to be able to do this for about 20 different Sales Reps. I hope this is enough information!

Thanks,

Keving

(in reply to keving)
 
 
Post #: 3
 
Re: Importing multiple .txt files into Excel. - 9/28/2004 7:16:08 AM   
  mbouchard


Posts: 1916
Score: 16
Joined: 5/15/2003
From: USA
Status: offline 		How are the text files setup? The reason I am wondering is that if they were a comma deliminated file, i.e. a csv, the import would be easier, essentially merging txt files. If not, then you would need to write directly into an excel spreadsheet. Also, do you want each text file on it's own worksheet or all on one? Do you want each line from the txt files to be on its own row? There are probably more formating questions but this is a start.

Mike

(in reply to keving)
 
 
Post #: 4
 
 
 
 

If you found our site useful please link to us <a href="http://www.visualbasicscript.com">VisualBasicScript.com</a>.
All Forums >> [Scripting] >> WSH & Client Side VBScript >> Importing multiple .txt files into Excel. Page: [1]
Jump to:





New Messages No New Messages
Hot Topic w/ New Messages Hot Topic w/o New Messages
Locked w/ New Messages Locked w/o New Messages
 Post New Thread
 Reply to Message
 Post New Poll
 Submit Vote
 Delete My Own Post
 Delete My Own Thread
 Rate Posts




Forum Software © ASPPlayground.NET Advanced Edition 2.5.5 ANSI