Results 1 to 2 of 2

VBA code to convert text file to Excel 2010

Threaded View

  1. 03-20-2014, 12:03 PM #1
    slin
    slin is offline
    Registered User
    Join Date
    01-11-2011
    Location
    Boston, US
    MS-Off Ver
    Excel 2013
    Posts
    9

    VBA code to convert text file to Excel 2010

    Hi Everyone,

    I am trying to convert a txt file to excel as below. I did a lot of search via google, but no VBA code fit to my case. Can anyone offer some help on my problem, any input is greatly appreciated!
    Attached is my sample .txt file.

    Supplier Name Supplier Num Taxpayer ID Site Name Address1 City State Zip Code
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Excel 2010-convert text to value
    By Ramsee in forum Excel General
    Replies: 19
    Last Post: 01-15-2014, 07:10 AM
  2. Excel 2010 file with VBA save and send code works-but file can't be found.
    By carlton.clay in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-13-2013, 09:46 AM
  3. Convert Text to Numeric Excel 2010 Pivot Table
    By zcheema in forum Excel General
    Replies: 1
    Last Post: 05-17-2012, 04:58 PM
  4. Convert Excel to formatted text file text file
    By rbpd5015 in forum Excel General
    Replies: 2
    Last Post: 01-14-2011, 10:27 AM
  5. VB code to auto save file as excel 2010
    By bryanc2k in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-14-2010, 01:44 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1