Read Data from a Text File using Excel VBABelow we will look at a program in Excel VBA that reads data from a text file. This file contains some geographical coordinates we want to import into Excel. Situation 1. First, download the text file and add it to C testPlace a command button on your worksheet and add the following code lines 2. We declare four variables. File of type String, text of type String, textline of type String, pos. Lat of type Integer, and pos. Long of type Integer. Dim my. File As. String, text As. Excel Vba Help File' title='Excel Vba Help File' />String, textline As. String, pos. Lat As. Integer, pos. Long As. Integer. 3. We need to initialize the variable my. File with the full path and the filename. File C testgeographical coordinates. Module-Excel-Bab-2-save-dbf.jpg' alt='Excel Vba Help File' title='Excel Vba Help File' />ExcelVBA Visual Basic for Applications for Microsoft Excel is the dominant programming language for Microsoft Office Excel. It is an eventdriven and object. A VBA Tutorial Read a Text File with VBA in Excel, and Write the Text to a Spreadsheet VBA can read a text file and then write it to your spreadsheet. Get. Open. Filename method of the Application object to display the standard open Dialog box and select the file without actually opening the file. File Application. Get. Open. FilenameNote the empty part between the brackets means we give Excel VBA nothing as input. Place your cursor on Get. Open. Filename in the Visual Basic Editor and click F1 for help on the arguments. Add the following code line Open my. File For. Input. As 1. Note this statement allows the file to be read. We can refer to the file as 1 during the rest of our code. Add the following code lines Do. Until EOF1    Line. Input 1, textlinetext text textline. Loop. Note until the end of the file EOF, Excel VBA reads a single line from the file and assigns it to textline. For all general questions relating to Excel but not including VBA or formulas. Excel Color Palette has an index of 56 colors which can be modified using VBA. Each color in the palette is associated with a unique value in the index that can be. Learn VBA with AnalystCave. The primary aim of AnalystCave. Visual Basic for Applications Excel Macros. Dazzle Fusion Drivers Windows 7 on this page. Where to startWe use the operator to concatenate join all the single lines and store it in the variable text. Close the file. Close 1. Next, we search for the position of the words latitude and longitude in the variable text. We use the Instr function. Lat In. Strtext, latitudepos. Long In. Strtext, longitude8. We use these positions and the Mid function to extract the coordinates from the variable text and write the coordinates to cell A1 and cell A2. RangeA1. Value Midtext, pos. Lat 1. 0, 5RangeA2. Value Midtext, pos. Long 1. 1, 59. Test the program.