+ Reply to Thread
Results 1 to 2 of 2

Crop Text to Col Width

  1. #1
    rrstudio2@icqmail.com
    Guest

    Crop Text to Col Width

    I have just started to learn about using VB to make macros for excel
    and would like a pointer. I need to export a space delimited text file
    that has more than 256 chars per line which means I can't use excel to
    export as .prn file. So the microsoft site has a macro for this at
    http://support.microsoft.com/kb/q131554/. The problem is, that the
    macro errors out if any columns have more text chars than the set col
    width. So, I was wondering, how would you make a macro that would
    simply crop the text in each column to the col width? There are abot
    30 columns with all difference widths, and I would just like to cut the
    text in them to the col width. For learning purposes, I would like to
    see a seperate macro that would just do this, however it would also be
    really cool to see this inserted into the microsoft macro.

    Thanks for any ideas,
    Andrew V. Romero


  2. #2
    Dave Peterson
    Guest

    Re: Crop Text to Col Width

    How about:
    http://google.com/groups?threadm=015...280a%40phx.gbl

    rrstudio2@icqmail.com wrote:
    >
    > I have just started to learn about using VB to make macros for excel
    > and would like a pointer. I need to export a space delimited text file
    > that has more than 256 chars per line which means I can't use excel to
    > export as .prn file. So the microsoft site has a macro for this at
    > http://support.microsoft.com/kb/q131554/. The problem is, that the
    > macro errors out if any columns have more text chars than the set col
    > width. So, I was wondering, how would you make a macro that would
    > simply crop the text in each column to the col width? There are abot
    > 30 columns with all difference widths, and I would just like to cut the
    > text in them to the col width. For learning purposes, I would like to
    > see a seperate macro that would just do this, however it would also be
    > really cool to see this inserted into the microsoft macro.
    >
    > Thanks for any ideas,
    > Andrew V. Romero


    --

    Dave Peterson

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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