Excel VBA - Import Data for manipulation from multiple text files
I have to gather information from an unknown number of text files wit
unknown filenames and import it into an excel document for dat manipulation. Each .txt file contains a series of data points entere by a data collection device. Each trial creates a new txt file an data file with no extention. Both can be imported into excel, but need to program a macro that will import data from these unknown numbe of files into a single worksheet in which the data can be compared an analyzed. I was wondering if there was a way to search through a folder and mov from one file to the next possibly pulling title information along wit the data within the file. There are usually 30 to 40 files each containing amost 100 data point each. The macro would prevent the tedious task of opening/importin all txt files and pasting them in an excel sheet. Please contact me a if anyone has any pointers of functions that might be able to research and apply. Thanks -- Message posted from http://www.ExcelForum.com |
Excel VBA - Import Data for manipulation from multiple text files
See the examples for the Dir function in VB Editor help which will do
what you want. Make a new post with a copy of your code if you get stuck. --- Message posted from http://www.ExcelForum.com/ |
Excel VBA - Import Data for manipulation from multiple text files
Thanks for the pointer. Now that I have some direction we'll see wher
I go -- Message posted from http://www.ExcelForum.com |
All times are GMT +1. The time now is 06:05 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com