I have a variety of text files that contains a string that is not of a fixed length. It could be similar to any of the three following examples. The variable string length is where I'm stuck.
Some stuff here
( G54.1P1 = X-504.13 Y-215.137 Z-244. )
More stuff
Even more stuff
Some stuff here
( G54.1P1 = X-504.456 Y-215.137 Z-241.129 )
More stuff
Even more stuff
Some stuff here
( G54.1P1 = X-503. Y-215.28 Z-244. )
More stuff
Even more stuff
I'd like to use a button, probably using Application.GetOpenFilename(), to find the text file, and place the 1st numerical value in A1, 2nd in A2, and 3rd in A3.
Bookmarks