import .txt

Hi everyone. Im working on a small macro that brings coordinates of points as (P X Y Z D) format. Ex: 1 4354 5456. 43.40 R 2 5432 6578 45.78 Corner 3 6578 6765 56.76 4 6548 9806 56.99 R . . ... Etc The probleme is that some files doesnt...

Hi, i am relatively new to VBA and i have problem importing data from text file. As the text file is too big, i do not want copy all data over to excel. Is there a way for me to create a VBA that only copies out all the rows with the same product ID as value in Cell A1? Then copy these rows...

I have a workbook that i copy each day, import a fresh txt file (created daily), format some columns to ensure text as they are numeric identifiers and excel always compacts them. I then proceed to run various macros against this data to conditional format and populate cells with formulas. This...

I have a text file which includes lines of text as shown below: 21599999902230123129285103920952123456789DOE, JOHN 0000000000000000000000000000000000000000000000000000000000000000000P019680201202112080000000000164221642200085013959...

Hello. I am trying to build a macro to import data from an external file that is generated with another program. I have two options for my source file; an .xml file and a .txt file. Both contain essentially the same data that I want to manipulate into my end product. My plan is to be able to...

I have a little VB knowledge but this one is way beyond my scope. This is a multipart problem I am trying to find a solution. We have a tab delineated text file with 11 fields that is constantly updated by another program. We would like to copy/import just two fields of that data, let’s say...

Hi there , I had write the following code to import txt file to excel without opening it. However, the code bring the data to a new workbook which is not something I want. What I want is to import the txt file into a sheet name "copy from text" within the same workbook "Data compilation" Do...

Hello Can anybody tell me a VB script wherein I have to export multiple txt files where the separator is instead of "," is "|"(vertical bar). I have seen multiple codes where the separator is assumed to be a "," but no VB script for "|" which is a separator. I have uploaded a sample txt file...

The goal is to import a text file using the path and file name contained in a cell that's a named range. I have a macro that I use daily to import a text file. The macro asks for the specific file to be imported. I would like to import the files without user input. The files to import are always...

I used to import tab separated text files as a range in previous version of Excel. I can still do it by enabling the "legacy" import wizard in Excel 2019; I can't find an easy way to achieve my end with the new power query of Excel 2019. I systematically get an Excel table which is not what I...

Hi guys. Okay, so I have a potentially really tricky one here... I have a design software, in which I can export a design to an item list in either a standard .txt Text document, or an overly detailed XML Document. Whilst the software allows me to specify what information to export to the .txt...

Hello, I have some *working* code that will open multiple specialized textfiles, delimited, as consecutive sheets in a NEW workbook. I need to make it open them as consecutive sheets within a workbook specified within a variable (variable currently being defined as active workbook, but have the...