+ Reply to Thread
Results 1 to 1 of 1

Import text files to current workbook

  1. #1
    Registered User
    Join Date
    11-17-2015
    Location
    texas
    MS-Off Ver
    2010
    Posts
    9

    Import text files to current workbook

    I found this code. Works great for allowing you to select multiple text files and import into new workbook as individual sheets for each file. I want to edit this code to import files into current workbook. I want command button to run script and add sheets into the same workbook instead of adding sheets to new workbook. Can someone help?


    Please Login or Register  to view this content.
    Last edited by JBeaucaire; 11-21-2015 at 04:19 PM. Reason: Added missing CODE tags. Please read and follow the Forum Rules, link above in the menu bar. Thanks.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Multiple Text files imported in the current workbook.
    By dazziphoenix in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-01-2014, 11:50 AM
  2. Import multiple text files into different worksheets in the same workbook
    By kalyanr12 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-30-2014, 04:29 AM
  3. Can I have Excel search another workbook for data and import it to my current workbook?
    By mgruber in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 0
    Last Post: 09-05-2014, 07:13 PM
  4. Import Multiple Text Files into Single Workbook with Different Sheets
    By oliver.marshall001 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-21-2014, 09:29 AM
  5. [SOLVED] Import multiple csv files into current workbook as separate sheets
    By santosh in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 05-31-2013, 04:19 AM
  6. Import multiple text files into 1 workbook
    By riddickisten in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 03-10-2013, 08:00 PM
  7. Help to import multiple text files to worksheets in a excel workbook
    By cookiemonster79 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-31-2011, 02:17 PM

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