Choose information from text file
Dear All
I have a text file named Result.txt with below information
BEAM NO. 1 DESIGN RESULTS - FLEXURE PER CODE ACI 318-02
LEN - 5000. MM FY - 420. FC - 30. MPA, SIZE - 200. X 250. MMS
LEVEL HEIGHT BAR INFO FROM TO ANCHOR
(MM) (MM) (MM) STA END
__________________________________________________ ___________________
1 64. 2 - 16MM 0. 4813. YES NO
|----------------------------------------------------------------|
| CRITICAL POS MOMENT= 14.00 KN-MET AT 2500.MM, LOAD 101|
| REQD STEEL= 209.MM2, ROW=0.0056, ROWMX=0.0223 ROWMN=0.0033 |
| MAX/MIN/ACTUAL BAR SPACING= 72./ 41./ 72. MMS |
| BASIC/REQD. DEVELOPMENT LENGTH = 292./ 230. MMS |
|----------------------------------------------------------------|
Cracked Moment of Inertia Iz at above location = 6358.9 cm^4
How can I pick some information in red colour from exel program by VBA
and place each number on a cell in exel program
Thank a lot
|