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 July 5th, 2006, 10:22 AM
Registered User
 
Join Date: Jul 2006
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default 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






Similar Threads
Thread Thread Starter Forum Replies Last Post
Converting Excel file into a text file zone Excel VBA 3 July 26th, 2007 02:09 PM
Transferring Access Report to Excel rklass BOOK: Access 2003 VBA Programmer's Reference 0 August 5th, 2005 08:46 PM
Transferring data between functions Fightfish C# 2 July 6th, 2005 12:21 PM
import data from text file to excel(VBA) topr Excel VBA 2 August 26th, 2004 11:36 PM





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