Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Excel VBA > Excel VBA
|
Excel VBA Discuss using VBA for Excel programming.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Excel VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old January 18th, 2006, 05:52 AM
Registered User
 
Join Date: Jan 2006
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Default 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






Similar Threads
Thread Thread Starter Forum Replies Last Post
How to export registration information asCSV file silu95421 Classic ASP Professional 0 October 27th, 2007 04:52 AM
Append Information to a XML file YoungLuke C# 2 July 26th, 2007 02:15 PM
Get information from text file Hoang2005 Excel VBA 2 February 5th, 2006 09:53 PM
File Information AndyHunt Excel VBA 3 December 9th, 2005 07:39 AM
ClassView information file Gert Visual C++ 2 August 4th, 2004 05:07 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.