Hello Friends,
I have a nasty VBA code that opens a *.txt file; searches inside the txt file for specific information limitted inside % ... %%% characters and paste them into separately sheets.
Also, It takes the first 8 rows of the file and add them into a new sheet, GENERAL.
What i'm trying to do, when loading the file, besides the above tasks, to search for 2 specific rows (with no fix position) and if they exist inside the *.txt file, to add them as well into the GENERAL sheet (position B12, B13).
The challange is that the rows are like this:
current-value-function1=88
current-value-function2=99
The rows to be added contains a fix part "current-value-function1=" + "number"
Can you please help me with the code sequence to add into the below one, to find these rows and insert them into the GENERAL sheet?
Thank you
Bookmarks