Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 08-16-2015, 11:44 PM
macropod's Avatar
macropod macropod is offline Loading Data automatically from several .txt files into different sheets of an .xls Windows 7 64bit Loading Data automatically from several .txt files into different sheets of an .xls Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,366
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Excel can't 'automatically' load files via formulae; you'd need a macro to automate the process. Such a macro could be made to work with the text you have in the columns, though you really don't need anything more than the text file's name (i.e. without the path & extension on every line) and you'd also need to put some code into the macro that would specify where on each sheet the data are to do.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Tags
different sheets, file path, import .txt file



Similar Threads
Thread Thread Starter Forum Replies Last Post
Loading Data automatically from several .txt files into different sheets of an .xls Need help consolidating data from separate sheets tiwas Excel 1 10-07-2014 04:57 AM
Combine Data From 2 Sheets into a new sheet bremen22 Excel 1 09-11-2013 12:59 PM
Loading Data automatically from several .txt files into different sheets of an .xls Word 2010 - Style Sets not fully loading / loading properly emilypage Word 3 11-09-2012 01:11 AM
Loading Image Files Into WORD Table cbjroms Word 0 10-19-2011 10:10 AM
Loading Data automatically from several .txt files into different sheets of an .xls How to syncronize data in two different sheets diegogeid Excel 2 09-30-2010 12:19 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:44 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft