Parsing data from text file

It would be useful to have some example code, or example workbook to base this on, but you should be able to use "Mid" you just need to work out what positions you want to extract.

cGys1 (219.85) cGys2 (109.92) cGys3 (54.96) cGys4 (32.98) cGys5 (10.99)

Ok, so we have 5 numbers we want to extract.
How do YOU know which numbers they are? - Each number enclosed within brackets.
Excel can do the same thing using the InStr function, which will look for one string within another starting at a particular position in the string (optional)

So something like this, where text_line is your line of text as quoted above:

Please Login or Register  to view this content.

I've commented the code so that hopefully you can see how to adjust it to fit your macro, but if you have any questions please do ask