text file

Hi all, I am trying to read in a text file and split it by character spaces and output to excel sheet, right now I can read in the text file, but I am having problem splitting it into an array by character spaces. Here is my vba code: Sub ParseText() Dim myFile As String, text As String...

I can create, copy / paste and save a text file to a specific directory (e.g. All of my data is on the 2nd row...so all of the data will be taken from H2, M2, R2, etc...) How can I make the row that contains my data variable or be able to select a different row of data? It could be one row at...

Hi All, I am looking to import data in text file to Excel sheet. Here is the main catch - All the data are not of fixed length and are in multiple lines as in the example below. Text File: ID001 Dr Dang 01012011 Male USA Married 123 Below is how I expected the data extraction in Excel...

I'm attempting to output data from Excel into a tab delimited text file. I've used this macro successfully before but in this case the users have data that displays as a percentage in Column 4. e.g. value is 73.3%. When I run this code against it the text file created displays the value as...

Hi all, I am new to excel macros and usually record macros. I want to create a macro that imports data from text file when ever it is updated. The text file is separated by TABS and I want the data to be recorded in a template. Can anyone tell me a macro code to do so?????????? :)

ppptrp03.p 1+ 3.6.13 Inventory Valuation Report Date: 17/09/13 Page: 1 Federal-Mogul Sealing Div Time: 19:56:21 Product Line: CHEM...

I am trying to replace the the string "VALUE=" with "VALUE= (Excel cell data)" where it first appears after a certain position within a text file (this certain position being "SOURCE"). The issue I'm having is that when I specify the start position within the REPLACE function, the newly saved...

Hi, I am trying to pass barcode data from excel to a text file and then back into excel. The barcodes are 8 or 12 character long and they can have or not have preceding zeros. I know of several ways to retain preceding zeros such as adding apostrophes before data or using custom formatting, but...

Hello - I have, with the expert assistance from a user here, the following code. I need to, however strip the text file it creates of the " marks Excel has decided to add in before I close the file created. Does anyone know how to accomplish this by possibly adding a line of code in? I think I...

Hello, I have been using Excel for a long time now, but I am just starting to learn the benefits of macros/VBA and I am loving it. I was hoping someone could help me with the code to import a .asc file into a workbook. I would like to create a button that the user clicks that asks them what...

Dear Frend I have a text file(Name.txt) having following data and i want to copy colored data in to excel sheet in different columns B E A M N O. 1 D E S I G N R E S U L T S M25 Fe500 (Main) Fe500 (Sec.) LENGTH: 3500.0 mm...

Hello, I have created a macro that pastes a range of excel data (via a loop function) into a .dat file, which is later FTP'd to another team. The only issue that I'm running into is that they cannot accept the file with a space at the end, which is unfortunately automatically entered into the...

(Reworded repost of http://www.vbaexpress.com/forum/showthread.php?t=39170 ) Overall questions (details to follow) =========================== QUESTION 1: Is there a way for VBA to search for specific data in a text file, copy a set length to another text file, before opening in Excel? QUESTION...

Hello I am writing a macro that changes the filepath for an existing text file import as a QueryTable. I want to set the connection parameters to variables and reapply them with a different filepath. Dim DataType() as Variant Dim Platform as Integer Dim TableCell As Range Dim...

I need help with a spreadsheet that I want to distribute widely. I put the introduction material and the instructions in 2 worksheets that do not look good. I would like to get rid of the menu bars. Since I do not want problems later, I do not want to reformat the text worksheets with macros...

I would like to split an excel file of 60,000 rows into small text files (.txt) of 5000 rows (or lines) Is there any way I can split one large excel file into many text files? I could find a macro that creates a text file from Excel data on another forum, but some how it doesn't seem to work...

Hey folks... I have two tab delimited text files that I'm trying to read into an Excel workbook which I've already created... I've been unable to find the code for reading a text file into an existing workbook, rather, the book I am using, "Writing Excel Macros with VBA" by Steven Roman only...

I have a spreadsheet of x,y coordinates and unique IDs. I need each line to written to its own text file. I'm not a programmer but I am a pretty good at copy, paste and tweak. Any guidance would be greatly appreciated!

I have a spreadsheet with data starting in column B row 11. Column C users input an X based on the data in column B they want in the text file. For example: Column B has data from row 11 to row 50, the user inputs X into Column C for each value in Column B that they want. Then by clicking a...

Hi, I have some code to read in several textfiles in specific sheets in a workbook. The problem is weird. -First, If the name of the textfiles is hardcoded everything works fine. -Second, if the name of the textfiles is read out fo the excell-sheet, it sometimes works and sometimes it doesn't...