Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Jan 2001
    Location
    Near Chicago, Illinois, USA
    Posts
    6
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Export a Range as text

    In 1-2-3, as old as version 2.01, you could save a range as text (space or tab delimited). I hve some programs that require ascii text as input, and have not been able to find a way to save the information as text without a really cumbersome workaround. Any help would be appreciated.

  2. #2
    Platinum Lounger
    Join Date
    Dec 2000
    Location
    Queanbeyan, New South Wales, Australia
    Posts
    3,730
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Export a Range as text

    Hi,

    Can you just highlight it, and copy and pate it into Notepad?

    If it's a whole workbook, you could save it as a tab-delimited text file.

    If you require something more sophisticated like that, a VBA solution would not be complex.
    Subway Belconnen- home of the Signboard to make you smile. Get (almost) daily updates- follow SubwayBelconnen on Twitter.

  3. #3
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Brisbane, Queensland, Australia
    Posts
    352
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Export a Range as text

    Try using Print to file using a generic printer.
    David Grugeon
    Brisbane Australia

Posting Permissions

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