+ Reply to Thread
Results 1 to 2 of 2

Import text to a table (used "format as table" thing)

  1. #1
    Registered User
    Join Date
    04-02-2012
    Location
    Brasil
    MS-Off Ver
    Excel 2010
    Posts
    20

    Question Import text to a table (used "format as table" thing)

    Hello guys,
    I'm in process of automating the input on several workbooks. The input sheet is formated as table so I dont need to copy the formulas all the way down.
    The way I do now:
    1- Open the main workbook
    2- Open the text file on excel
    3- Text to columns on the text file
    4- Copy text to the bottom of the main workbook
    5- Done, all the formulas are copied down along the data I just pasted.

    But if I input the data through the "import from text" tool the table is not updated.
    Similar problem when I need to import data into a table, instead of placing the data inside the table, the excel insert new columns, paste the imported data there and move the table to the right.

  2. #2
    Forum Expert Tinbendr's Avatar
    Join Date
    06-26-2012
    Location
    USA
    MS-Off Ver
    Office 2010
    Posts
    2,125

    Re: Import text to a table (used "format as table" thing)

    Don't use the import tool. Just open the text file and write it into the range required.

    Look at open, Input and Line Input. Or post sample text file and where it's supposed to go.
    David
    (*) Reputation points appreciated.

+ 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