1. R

    Create .TXT Subsets based on existing Excel data using VBA Macro

    Hello Guys, I need to create Subsets for the data which I have, which is dynamic, using Excel VBA. I have data in the form of table, whose column headings are Code, % & Transaction ID as the below table. Code % Transaction ID 1001 42.10% 455152 1001 42.10% 455153 1001...
  2. K

    Automated conversion from TXT

    I have a txt file that needs to be converted from txt to csv with excel. Process needs to be automated and I am not sure how to do this at all. Any input would be a big help. The deliminator is a | Thanks Keith
  3. J

    LEFT() for each rows in a single cell?

    The following data is in a SINGLE cell. I'm trying to get the phone number from each line and output it as just a list of phone numbers in a single cell. FROM THIS: <tbody> (734) 435-8519 < Sent TXT 14/25/09 @ 08:54 (734) 917-1416 < Sent TXT 14/25/09 @ 08:54 (734) 742-6437 < Sent TXT 14/25/09...
  4. J

    Search in TXT file and return line to Excel

    Hi there to evereybody! Im Juan and i'm writing from argentina. I have a TXT file with millons o lines (literally) like this: 22082019;01092019;30092019;20000163989;D;S;N;0,00;0,00;00;00;ETCHEVERRIGARAY JUAN CARLOS I would like to use a command button to search for the number i've marked...
  5. M

    Add Filename to the txt file

    I have a small script that logs when a user opens an excel file. Currently the username and date/time are populated in the txt file. I would like to add filename to the txt file, but not sure how. Thanks Private Sub Workbook_Open() On Error GoTo errhandler: Open "D:\Reports-Service\Old...
  6. Belair58

    Graphing from a $ delimited txt file

    Hello, I'm outputting a delimited txt file using $ as my delimiter from SQL server. This file will be output once every 5 minutes. I'm wanting to graph this data on a continuous basis. I'm trying to link it through Data / From Text/CSV, but it doesn't give me the option to choose the delimiter...
  7. D

    For each cntl trigger class module

    Hi I've dynamically created a number of textboxes on a userform. Each textbox was added to a class module with some associated attributes. I also have a number of option buttons to the side of the userform. By clicking the textbox, i can update the text in the textbox from the asociated...
  8. M

    read from .txt and extract data

    Hi All, I need to read a txt file and dump the data into a spreadsheet. each txt file with contain two different data sets always starting with DXE and ending with DXS Id like to extract the first set in to column A and second set into column B the data needs to be inserted row by row...
  9. M

    Loop through txt doc , store values for use in vba

    hi all, Just a question of possibility first of all. I have a .txt file that contains two sets of data. The sets always start with DXS and end with DXE. First of all, I would like excel to read the .txt and take only the data between DXS and DXE and dump them side by side 1 line per row in...
  10. H

    How to exclude some of the excel range from the output to text file

    The code I have is following: And the data it is extracting from is this: As you see, the amount of data there might be, varies, but the extract takes a fixed range into account, to cover everything. Now there is a problem, it extracts indeed all the data, but also creates a lot of...
  11. 1

    VBA to find next value

    Hello, I have a bigger macro that open many TXT files one by one, search for different values and copy after in a data sheet. At one point I need to find the value for "Code" which is a number. If TXT file is opened by Excel, this value is in column A and the position of row can be different...
  12. M

    VBA to trigger multiple batch files not working

    Hey everyone. I have code to trigger 6 different batch files, which then outputs a txt file, which in turn i use power query to bring the txt file list into excel. I thought it was working fine until one day I noticed the date stamp on the txt file had not changed in a week, despite running the...
  13. J

    Trouble Copying from txt file to Excel - pastes into one cell only

    Hello. I'm trying to paste from a txt file into Excel. I can successfully paste into ONE cell, but I need it to paste into multiple cells. E.g. the txt file looks like this: 1 2 3 4 5 6 With my code below (admittedly pilfered from someone else!), it pastes into A1, but it pastes ALL data into...
  14. E

    Reading TXT file strange behavior new lines??

    While reading a TXT file the following occurs: Such a line like: "31/07/2019 TOTAL" At this line I suppose the "Input #1 , sTxt" instruction is reading read as there was 3 lines in the TXT file: "31" "07" "2019 TOTAL" I expect that this instruction will read the entire line "31/07/2019...
  15. S

    [VBA] extending Autofilter to filter with multiple words, using wildcard

    The following codes only manage to filter for 2 words. (i.e. txt, txt) When user inputs more than 2 words to filter (i.e. txt, txt, txt), an error just returns. Is there any workaround to filter more than 2 words, for a particular column? Thanks! Sub Test() iTxt = InputBox("containing ...
  16. J

    Select value in html dropdown with vba

    I’m trying to select a value on the html dropdown box with excel vba code (as far as I know the html is javascript) but I’m not good at html. I have tried every possible proposal from various forums, without luck. The web page is an internal company page, so unfortunately it cannot be shared...
  17. K

    Txt file convert to .xls

    hello. I wish to convert a txt file that is saved down in my folder into a .xls file. Before I do this however I need to sort by columns and I wish to sort by using the delimited file type - Other | key. Once created as a .xls file. I need to import the file into my workbook under...
  18. S

    How to edit all queries/connections from one delimiter to another?

    In my Excel file, I have imported many txt files with tab delimiters manually (Data tab -> Import data -> From Txt). Each txt file is imported into its own separate sheet. The delimiters are recognized and the data within each txt file is neatly imported into separate columns, as shown in the...
  19. J

    VBA: Find start and end text in TXT file, copy all data in between to specified Excel Column

    I'm trying to get data from multiple TXT files into Excel. Each TXT file represents 1 row of data on the excel workbook. Each section of text the TXT file represents the corresponding column in that row. For example: Everything after "Other Observed Names" would go in a column labeled "Other...
  20. P

    Read 2 files and save in 1 worksheet

    https://pastebin.com/raw/YAYfZ99AHello. I have little trouble. Im really green in VBA but i know about it can be dont in VBA. I have 2 folders with tons of txt all txt have the same name in 2 folders but having another data. ex. Folder1/1.txt Folder2/1.txt Folder1/2.txt Folder2/2.txt Example...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back