text file import

Hi everybody, I got the following problem: I need to get data from round about 500 text files. Problem one is that I just need a part of each text file, (the part I need always stays the same) Problem two is that I dont have enough time to manually convert all the text files one by one. The...

Dear All Master, I want to import from text file to excel and want the desired result as below and for column H I mark yellow then the result must be text. I also attached a text file link thanks roykana DESIRED RESULT ABCDEFGHIJKLMNOPQR1No Transaction Date...

I work for a sheet metal manufacturer and would like to use VBA to loop through a directory of text files (that are created as setup sheets when machine programs are generated) and extract meaningful information to Excel for further analysis. All of the text files are generally structured the...

I have written a piece of code that asks the user to open one text file and it loads it into an Excel sheet. Then asks for a second text file which it loads into another sheet. Then runs through the second sheet to find corresponding records and when it does it compares a column of data. This...

Hello, I am having trouble splitting the data I have in a Text file into separate columns in power query. The columns in the text file are separated by a series of five spaces instead of a tab. This means that the normal method of using split comma with the delimiter does not work. The...

I'm helping a friend with a research project and I've met my match. She has roughly 1000 .txt files that contain data (when opened in excel) in A15:IV254, (yes, that's 61,440 data points per sheet!) and she is trying to a. find the max value in each file, b. find the cell location of that...

Hello All, So, my company has roughly 40,000 documents ( some 1 page, some 100 pages long) all stored on the intranet. Our team need to go thru all of these documents and obtain certain information from them. So we start by going to the intranet, pulling one form down and opening it. I have...

Hello, I am wondering if it possible to bypass the pop-up window prompting to select the text file when refreshing data imported from text file. I have a tab separated text file that gets updated by an external program. I find it annoying that I need to select the file every time I want to...