[HELP] How to extract specific text from from .txt file to excel vba

[Holiday_Drew]

Hi Sir,
Question if I want to get the information on the text file please see red color that is the information I need to get what will be the code I will use button also I just want All .txt files in the "C:\Users\Andrew Sangalang\Downloads\Logs" folder are to be processed I have many text file in one folder i need to get all five minutes: result and extract to worksheet


BALAGTASBCISR2#!
BALAGTASBCISR2#show proc cpu sorted | e 0.0
CPU utilization for five seconds: 0%/0%; one minute: 1%; five minutes: 1%

Please help me thanks a lot!

 

[Holiday_Drew]

Hi Sir,
Question if I want to get the information on the text file please see red color that is the information I need to get what will be the code I will use button also I just want All .txt files in the "C:\Users\Andrew Sangalang\Downloads\Logs" folder are to be processed I have many text file in one folder i need to get all five minutes: result and extract to worksheet


BALAGTASBCISR2#!
BALAGTASBCISR2#show proc cpu sorted | e 0.0
CPU utilization for five seconds: 0%/0%; one minute: 1%; five minutes: 1%

Please help me thanks a lot!

Hi Guys,

Please help me regarding this I'm a newbie only using excel vba.

Thanks a lot!