+ Reply to Thread
Results 1 to 2 of 2

Iterative process to import multiple text files into multiple excel files

  1. #1
    Registered User
    Join Date
    10-18-2018
    Location
    Thessaloniki , Greece
    MS-Off Ver
    2016
    Posts
    3

    Iterative process to import multiple text files into multiple excel files

    I am getting txt output from fortran that i want to use in excel for some analysis.

    then i use another file to reshape the data into another format and compare it for analysis using some standard data i already have
    I ve done the process a few times
    The import and reshape process happens to those using VBA into Sheet1 spreadsheet of "Sample.xlsm" and copy them into the "BRING" spreadsheet of "Sample.xlsm"
    I want to Save As the xlsm with the current textfile name i got the import from
    And in the long run to make this process iterative for every txt file in a given folder

    I made a sad little macro using my very little skills and macro recording in VBA that imports the data into sheet1 but i had to manually save after each iteration
    I m very unhappy as i m going to use the trial and error method to decide what the optimal values are going to be for my method, therefore i will be importing many sets of data.

    I m really looking for some help though since we are talking about over 100 text files , thank you very much in advance guys

  2. #2
    Forum Expert
    Join Date
    10-09-2014
    Location
    Newcastle, England
    MS-Off Ver
    2003 & 2013
    Posts
    1,986

    Re: Iterative process to import multiple text files into multiple excel files

    Can you upload the worksheet you have with the "sad little macro" in? Chances are you're already half way there and just need a few additional pointers.

    Attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
    If someone has helped you then please add to their Reputation

+ 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. Import multiple text files to different worksheets in Excel for Mac
    By bertram25 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-10-2015, 10:18 AM
  2. Import Multiple text files in different worksheet into Excel 2010
    By rageshprasad in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-06-2014, 07:16 AM
  3. Import multiple text files into excel
    By bginsberg in forum Excel Programming / VBA / Macros
    Replies: 19
    Last Post: 11-20-2013, 04:05 PM
  4. Macro to import multiple text files into one excel (2007) sheet
    By schthi3 in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 10-08-2013, 11:35 AM
  5. [SOLVED] Import Multiple Text Files into Excel - for beginners
    By rapidasia in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 09-04-2013, 06:39 PM
  6. Import multiple text files into excel
    By jdbaba in forum Excel General
    Replies: 1
    Last Post: 11-19-2011, 04:32 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