text files

Hello all, Hoping to find some assistance with a pesky task. Each week, I run a report that produced a text file. This task is going to be handed off to other individuals with limited Excel experience and need to automate as much as possible. I have been successful in prompting the user to...

Hello everyone, I'd appreciate some coding help in Excel using VBA. I'm very new to this. Background: There is a new .txt file made for each machine run, which contains details about the part and the weight gain. The .txt file is created automatically in the system, and goes unedited by...

Hello everyone, I'd appreciate some coding help in Excel using VBA. Background: There is a new .txt file made for each furnace run. The .txt file is created automatically in the system, and goes unedited by anyone, therefore using the date last modified is a viable way to sort through the...

I have separate text files that need separate editing at the same time always. I would like to find a way to have Excel open each file in a downward column so that I can edit each line side by side. Example would be, I need to go to line 40 in row one, change some text, tab to row 40 on next...

Hi Guys, I'm having trouble finding the best way to extract data from a text file. Below is an example of the text: 09-27 +0.81 12-12 +0.56 02-16 +0.19 03-01 +0.02 LO HI L3213141 X 22 Y= 44 Z 66 Mean Range 6 Sigma Samples +0.2 0.1 +11 19 I= 0.056 J 0.533 K 0.813 F FLUSHNESS...

Why is it so difficult to import access file on Mac, like you have to download softwares. Is there a easier way to do it?

Currently have a working script that uses FSO, but it also opens .xlsm files within my working directory. I would like to to only open .txt files. I found this code that should work, however I can't figure out how to apply it to my situation: Sub test() ' Loop thru all files in the folder...

Hoping to get some help on this, first time working with opening text files and 3 dimensional arrays. Getting an error on line: For Each file In folder.Files Problem: I am trying to write a script that will open all the .txt files [within the working folder of the excel workbook], and...

I have a list of spreadsheets that may or may not have macros and functions in them. I am looking for a macro that would: Look at each file in a list of spreadsheets in Excel 2010 or 2016, Open each spreadsheet and if there is code for a macro or a function save into a text file named the same...

Hello, I am trying to create a macro tool based on the report which should be uploaded into excel sheet from text file. The problem is that each report uploades into different cells. I have two copies of reports from two months. They are the same in layout. Despite that they load differently...

I am having to set up a workbook for our purchasing department that compares two daily exports from our database and tells her what to order to maintain appropriate levels of inventory. I can make all the formulas and know how to get this to work if the two exports were excel files. Can the...

Hi folks, I've seen a few similar posts to this but not one that seems to fit my needs. I'm looking to import multiple text files into the same sheet, placing subsequent text files below the previous one. I'd also like to remove the headers in the text file (just the first row) as the files...

I have text files that I need to modify, using formulas, in Excel 2007, and then convert back to text files. I have tried repeatedly to do this, but have found that my files, once saved and reopened, unpredictably contain cells that are surrounded by quotation marks. This does not affect all...

Hello to everyone, I wrote a code, which allows me to automatically import the Text (.txt) files (that are located in the same folder) on different worksheets (according to a certain criteria). But I have a problem with the duplication of data: I would like to import one text file only...

Hi guys, I'm looking for a way to import multiple text files into one excel spreadsheet, with the files being imported one below the other. I'm currently using CPearson's code to let the user select and import a text file to an excel spreadhseet. However there are three text files that I want...

Hello and thank you for your expertise. Here is my situation. I have approx. 500 text files all residing in one folder. This folder only contains text files. Each text file has approx. 100 rows of data, tab delimited. I would like to import every row from each file into one sheet in...