reading data

Hi Guys, I'm having trouble finding the best way to extract data from a text file. Below is an example of the text: 09-27 +0.81 12-12 +0.56 02-16 +0.19 03-01 +0.02 LO HI L3213141 X 22 Y= 44 Z 66 Mean Range 6 Sigma Samples +0.2 0.1 +11 19 I= 0.056 J 0.533 K 0.813 F FLUSHNESS...

Hello All, I have red many of Forum seeking for VBA solution for my issue, I found a couple of good one but non of them was completely useful for me... I am not professional programmer, so pls help me.. I have a 260.000-line-long logfile and my boss tasked me to pick up some information...

Hello, I am working on a tool for teachers to track their students most current reading levels. In column G, I need to pull the most recent cell from a non-contiguous range, I am attempting to use the lookup formula for this, but I am having trouble stating a non-contiguous range. The...

Hi, I have a small query regarding if then Else. I need VBA to read a certain cell and depending on the value run through two different lines of code. I'm having problems getting VBA to read the underlined code. My code below is Sheets("Sheet2").Select myFileName =...

Hi Sirs, I have a problem regarding sorting our books on our store. The database extracted in textfile is somehat like this <bookstart <bookstart <bookstart **BOOKSTART SERIAL=3234123532; AUTHORSN=12343234; CASE=11; CLASS=1-1-101-241-33-NONE-0-NONE-00000000-65535-0-0-DP_UPS-NONE...

Dear all, I've been making a large Excel file with lots of data and formulas. Its supposed to be a system for a specific department. I've made a sort of loading screen/splash screen when starting up where it says please wait while the program is loading. then at the same time the workbook...