+ Reply to Thread
Results 1 to 4 of 4

Text to Columns macro

  1. #1
    Registered User
    Join Date
    08-17-2009
    Location
    Chennai, India
    MS-Off Ver
    Excel 2003
    Posts
    2

    Text to Columns macro

    Hi all,

    I need to automate the Text to column function (Data --> Text to Columns) using macro. The size of each cell should be dynamic i.e., the size of each cell will be stored in a location in the workbook and that should be used.

    Please help. Thanks in advance.

  2. #2
    Registered User
    Join Date
    08-17-2009
    Location
    Mumbai India
    MS-Off Ver
    Excel 2007
    Posts
    61

    Re: Text to Columns macro

    Please Login or Register  to view this content.
    Last edited by raghunaik; 08-17-2009 at 09:20 AM.

  3. #3
    Registered User
    Join Date
    08-17-2009
    Location
    Chennai, India
    MS-Off Ver
    Excel 2003
    Posts
    2

    Angry Re: Text to Columns macro

    Thanks for the reply. But still the solution is not yielding the required results.

  4. #4
    Valued Forum Contributor mudraker's Avatar
    Join Date
    11-10-2003
    Location
    Melbourne, Australia
    Posts
    3,983

    Re: Text to Columns macro

    It sounds like you will spend more time keeping the field size listings up to date than you would spend doing text to column manually


    Is the field size listing be kept in the same book as the macro

    Will you have mutiple listings for different file types/info
    Please Read Forum Rules Before Posting
    Wrap VBA code by selecting the code and clicking the # icon or Read This
    How To Cross Post politely

    Top Excel links for beginners to Experts

    If you are pleased with a member's answer then use the Scales icon to rate it
    If my reply has assisted or failed to assist you I welcome your Feedback.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1