txt

Hello Everyone, I am converting 500 text files to CSV files by just changing the extension from .txt to .csv. The problem is, the the data in the text file is splitted into multiple columns of the first row of csv file. My objective is, when I convert the text file, then all...

Dears, I'm struggling to find a way to save an excel file like a ".txt UTF-8". I used to simply save my file like a .csv (comma delimited), but now I have to deal with Chinese characters and I learnt from internet that chinese/japanese/korean characters have some kind of issues and aren't...

I have over 100 text files and each of them has two columns of numbers, the columns are separated by space, they are stored under the same folder. The final goal is to import all of the text file into a single excelsheet, and i want only the second column of each text file showed up in the...

Hi all, I'm looking to navigate to a folder, select txt files, and import each onto the same worksheet in an existing workbook, one after another (vertically). I found some code on; Importing Multiple Files to a Single Workbook (Microsoft Excel) which almost does exactly what I need, although...

Hello guys! I made a C++ .EXE program that generates in a txt file points of a Fourier series of a given function. The program is working just fine. It generates the data and I can, manually, import these to excel to create the charts. Marvelous. The problem is when I try to automate the...

Hello guys! I made a C++ .EXE program that generates in a txt file points of a Fourier series of a given function. The program is working just fine. It generates the data and I can, manually, import these to excel to create the charts. Marvelous. The problem is when I try to automate the...

Hi, I hope you can help. I am trying to import into an excel sheet a CSV file, one of the columns in the CSV is a URL, Excel is delimiting on the : of the url in addition to the commas. Importing the file manually works, but even if I use the screen recorder to record this it does not run...

Dear Users, I'm having trouble to export a selection via the following code in VBA. Some of the rows actually do get exported but I get Runtime error 13 Type mismatch. Actually rCell.Value gives me error 2023 (xlErrRef 2023 #REF!) I have played with the starting row of Set ExportRange =...

Hello everyone,:) I'm using excel 2013 and i have a big challenge, i have a big txt file, with more than 400000 lines. Some parts of this file i need to extract and to add them into excel, under different sheets. These paragraphs are delimited by % as the beginning and %%% as the end of...

I have one tag I need imported, along with the file name, from multiple TXT files into 1 Excel file (preferably Column 1 file name, column 2 the tag shown below). I only need the text within the tag. <phrase translate="true">REVISION TIBIAL SLEEVE SEPARATOR - DRIVER</phrase> Excel example...

I have searched the internet but have not find the proper solution; however it seems that several users have the same problem. My current client receives a .csv comma delimited files from the source. In these files, some fields contains commas that appear in a text file in double quotes. Editing...

I am currently working on a piece of VBA to output a list of headings and associated values with those headings to a .txt file. I currently have a set of headings and a set of values all in one worksheet and an excerpt of the working code is shown below: Sub Print_To_File() Open...

Hi guys, Please I have this VBA code which combines multiple excel workbooks into one excel sheet as long as all the xls files are in one folder and no other file formats in it. Here is the code Option Explicit Public strPath As String Public Type BROWSEINFO hOwner As Long pidlRoot As...

Hi! i need help:confused: I have a .txt file, how can i convert it to an asc file??? Thanks

This has been an ongoing problem that I can not figure out. Every time I open a file in excel (.txt or .csv) with html script, it parses the script as well as the columns. These files are coming from an outside source so I do not have the liberty of asking them to use a different delimiter to...

I'm very new to VBA. I've done my best to copy and paste from forums like this one and then alter it for my purposes, but obviously that can only get you so far. I am trying to get the following code to repeat adding the rows and the text for every time the word "Date" appears in column c. I...

Hi guys, I am new to this forum, so I hope you can help me out. I have a folder with say 20 different .TXT files that all need to have a VBA script run through. I have created the VBA script, but I can only get it to work one at a time. I was therefore wondering if it would be possible to add...

Hi guys, So this is what my workbook does in short: Opens up and updates a table from .accdb Updates relevant data from an external source I then need to save this data back into a text file to rewrite back into the database. The problem is that I'm getting "" at the start and end of every...

hey all, hopefully you can help me with this. I will be having a series of TXT report files coming my way that are arranged in a certain, uncomfortable way. This is how they look below...