Transferring data from text file to Excel
I want to transfer data from text file into MS excel using some VBA script or macro. I am new in VBA. The data in text file is shuffled data and column headers. I want to take the column headers and the corresponding data to excel file by checking on particular column headers. Following is the the format of data in text file to be sent to Excel in formatted way:
REPORT RPT149 ACCOUNT LEDGER PAGE 1
ABC BANK 2
BRANCH 001
ACCOUNT NUMBER ACCOUNT NAME ADMIN OFFINV OFF PERIOD ENDING
01-0001-00-6 DEMAND NOTE OFFSET ACCOUNT VXS NIA 01/30/04
ACCOUNT TYPE INT ACT-CASH
DATE TRANSACTION DESCRIPTION INCOME PRINCIPAL CARRYING VALUE
" BALANCE FORWARDED 12/31/03 .00 1,351.85 346.50 "
01-02 1 04010228744 999100-40-7 034 .00 .21 .00
INT THRU 12/31/03
GENERAL ELECTRIC CAPITAL CORPORATION
DEMAND NOTE
|