how to retrieve a specific value from a text file with visual basic in excel

katia 1 Reputation point

Dear all,

I have a text file from which I want to retrieve a specific value from a specific line. Let's say that my text file with many lines out of which I am interested in specific data for example:

clusters, rings

tik = B01

sep = C01, G1

shades, colors

1) I want to retrieve the value which comes from the line that starts with #tik after =. So I want only B01. How can I get it?
2) And if I want the value after the comma from the line that starts with #sep (ie G1), how can I get it as well?

Thank you in advance,

Not Monitored
Not Monitored
Tag not monitored by Microsoft.
37,618 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Anonymous

    Excel is not currently supported here on QnA. They're actively answering questions in dedicated forums here.

    --please don't forget to Accept as answer if the reply is helpful--

    Regards, Dave Patrick ....
    Microsoft Certified Professional
    Microsoft MVP [Windows Server] Datacenter Management

    Disclaimer: This posting is provided "AS IS" with no warranties or guarantees, and confers no rights.

    0 comments No comments