Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 08-12-2015, 07:22 AM
lookingforananswer lookingforananswer is offline Loading Data automatically from several .txt files into different sheets of an .xls Windows 7 32bit Loading Data automatically from several .txt files into different sheets of an .xls Office 2010 32bit
Novice
Loading Data automatically from several .txt files into different sheets of an .xls
 
Join Date: Aug 2015
Posts: 1
lookingforananswer is on a distinguished road
Default Loading Data automatically from several .txt files into different sheets of an .xls

Hello everyone,

I have the following problem:



I´m trying to analyze several measurements in one excel Worksheet.



Therefor I did several measurements, which resultet in a single .txt (tabulator seperated) file for each measurement.

If I drag and drop (copy paste works too) the .txt in an excel sheet, everything works fine but it is a lot of work for the amount of different measurements, so I would like to automatize the process.

The xls. file consists of the main sheet with all the diagrams and statistics which use the data from the measurements that are stored in seperate sheets in the same .xls file.

My main idea is, that on the overview sheet I provide the name of the sheet which should contain the measurement and the file path of the corresponding .txt file of that measurement and excel should automatically load the data from that .txt file in that sheet, as if I had done it by hand via drag and drop.


How can I realize that?

In the picture I have showed the basic structure of the file system and the .xls with the different sheets for each measurement .txt file.
Attached Images
File Type: jpg Capture.JPG (183.7 KB, 17 views)
Reply With Quote
 

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 11:15 AM.


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