"Can this code be updated to export the text coordinates, Value and layers to excel?" YES but new code. Can send direct to excel.
Last number can be found by searching text and checking its value, > oldtext newtext, so save highest value as a number.
I just wonder why a point manager Hint Lee-Mac, was not used in 1st place if these are imported points. Or if they have been manually added why not use a block with POINT & 1 Attribute. Much easier to handle than plain text.
Please respond about where points are coming from. Have a couple of off the shelf solutions.