Need help on String Extraction from a cell based on start string and end string

Team,

I have 10000 lines in a particular Cell. Say "A1".

In each and every row, i will do a search on a particular string and once it finds then it should go through the entire line of code in each row and extract it until it find the second string and extract it and store in a array and put them in a notepad file.

1. Please see the following lines of code:-

(case when ( ges.hlth_cov_cls_cd )= 'DG' and ges.src_sys_key = 203 then 'MEDICARE PART D'
when ( ges.hlth_cov_cls_cd ) = 'DG' and ges.src_sys_key = 199 and substr(( ges.cov_serv_id ),1,2) = 'RM' then 'MO DUPLICATED DRUG'

2. I will provide start string as "ges." and end string as "="

3. I need to fetch the strings that starts with ges.. ie., ges.hlth_cov_cls_cd before the "=" symbol and it should navigate throw the next occurrance of the start of the keyword (ges.) i.e., ges.src_sys_key before the "=" . then the both the string ges.hlth_cov_cls_cd and ges.src_sys_key should be stored in a text file and if there is a provision to store them under Column B, that will be very helpful.

Is this possible in VBA and if so, can i get the code and also i am new to VBA and request to provide end-to-end instructions to carry out the task.

Regards,
Premnath




_