Hi,

I'm a noob trying to get up to speed on some fairly complicated xlsx files and VBA.

But one thing the expert in the office can't remember is when he has VBA code to look through a .txt file,
return all the text between the white spaces.

currently he has code that will pull a specific number of digits (kinda like mid(4,6) )

this works ok usually but sometimes the number of digits in the txt report we are pulling from changes. and time looking through the code or the txt file eliminates the time saved by using the vba code.


Its probably stupid and easy but google hasn't been any help....