Excel User Group
Microsoft Excel blogs, forums, files. Read, ask questions, provide answers.
Forums » Excel Forums » Excel 2007 and 2010 » Automatic text-to-columns on updated web data

Automatic text-to-columns on updated web data

Previous | Next
Latest post Wed, Jun 9 2010 8:24 AM by Bob Phillips. 1 replies.

  • Tue, Jun 8 2010 9:40 PM

    • ecokev
    • Not Ranked
    • Joined on Wed, Jun 9 2010
    • Posts 1
    • Points 21

    Automatic text-to-columns on updated web data

    Reply |Contact

    Hi there folks,

    I would like to find out if it is possible to automate a text-to-columns command each time my data updates from a web source. Currently the data source is separated by commas and I use the text-to-columns to split the data into three columns. When the data updates, it lumps everything back into one column and I have to manually repeat the text-to-columns command many times over.

    Many thanks,

    Kev
    • Post Points: 21

  • Wed, Jun 9 2010 8:24 AM In reply to

    Re: Automatic text-to-columns on updated web data

    Reply |Contact |Mark as Answer

    Just repeat those actions with the macro recorder on, and assign the code to a button.

    Regards

    Bob

    • Post Points: 5
Page 1 of 1 (2 items) | RSS
Copyright Excel User Group and the relevant contributors, 2010. All Trade Marks acknowledged. This site is a peer-to-peer site and NOT affiliated in any way to Microsoft Corp. All rights reserved.