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.











LinkBack URL
About LinkBacks
Register To Reply
Bookmarks