[ExcelVBA] need Vba script in excel

 

Hi,

I need a vba script and input file & output file is given below. Input file was saved in text format.I need to collect the U#############AMA & record count in output file

input file:
===========

INFO SDM BILLING DISK
STREAM= AMA: File /sba/ama/closedNotSent/U120125011383AMA
has been moved from Open to ClosedNotSent Record Count: 25002

INFO SDM BILLING DISK
STREAM= AMA: File /cbmdata/00/billing/ama/closedNotSent/U1201
25183601AMA has been moved from Open to ClosedNotSent Record Count:
167971

Desire output file:
===================
U120125011383AMA 25002
U120125183601AMA 167971

Please provide the vba script.

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (1)

Recent Activity:

• New Members 7

Visit Your Group

----------------------------------
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.

----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA

----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com

----------------------------------

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___