+ Reply to Thread
Results 1 to 3 of 3

Load multiple modules names & forms names from multiple files into destination file

  1. #1
    Forum Contributor
    Join Date
    05-24-2021
    Location
    Palestine
    MS-Off Ver
    2019
    Posts
    280

    Load multiple modules names & forms names from multiple files into destination file

    hi

    is there any some procedures to bring modules , forms with all the codes are existed into them from multiple files? for instance the destination file is OUTPUT when I open file should brings modules( SAL1,PUR1,MN1) and forms( FRM1,FORM2,FTR3) from file INPUT and bring modules( INV,CATE,MM) and forms( RET1,RET2,PPT) from file SUMM

    so the all files are existed in the same folder(D:\FILES\) .I wouldn't do that manually to open file and copy the modules & forms and paste it will take much time .
    thanks

  2. #2
    Forum Contributor GWteB's Avatar
    Join Date
    12-13-2021
    Location
    GMT +1
    MS-Off Ver
    2013
    Posts
    136

    Re: Load multiple modules names & forms names from multiple files into destination file

    Hi, there are multiple sources on the internet regarding this topic, for instance:

    https://gist.github.com/steve-jansen/7589478

    https://www.rondebruin.nl/win/s9/win002.htm
    Did this help? Say thanks by clicking the ★

  3. #3
    Forum Contributor
    Join Date
    05-24-2021
    Location
    Palestine
    MS-Off Ver
    2019
    Posts
    280

    Re: Load multiple modules names & forms names from multiple files into destination file

    thanks for links are very useful !
    actually i choose second link because threre is import the modules & forms .
    honestly this is not fit for what I look for it , because based on code create new folder and brings all of the modules & forms from multiple files , but my needs should brings specific modules & forms( ignores the others modules & forms ) into the file where run the macro from of it. and to modifiying it this needs a lot of work and this is hard for me.

+ 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] Macro to extract file names when importing multiple files
    By Howardc1001 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-21-2021, 01:00 AM
  2. [SOLVED] Importing data from multiple files changing file names
    By rhodestransit in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-18-2020, 10:52 AM
  3. Importing multiple .csv files into one new excel file - problem with sheet names
    By jts5814 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-20-2016, 12:14 PM
  4. copy specific cells from multiple .xlsx files into a table in destination file
    By khhleung in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-09-2014, 07:18 PM
  5. VBA to open multiple files with different, unknown file names
    By jreed52 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-28-2014, 12:03 PM
  6. [SOLVED] Create multiple files with file names the same as cell value
    By Ocean Zhang in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-05-2013, 10:35 AM
  7. Consolidate Data from Multiple Files (Different File Names) into a Master File
    By dspraveen_23 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 12-08-2012, 12:59 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