+ Reply to Thread
Results 1 to 3 of 3

Import all Userforms from a directory into active Excel Workbook?

  1. #1
    Registered User
    Join Date
    01-14-2015
    Location
    Wisconsin, United States
    MS-Off Ver
    2013
    Posts
    5

    Import all Userforms from a directory into active Excel Workbook?

    Does anyone know how to import all Userforms from "C:\Chris" into active Excel Workbook?

  2. #2
    Forum Expert
    Join Date
    01-23-2013
    Location
    USA
    MS-Off Ver
    Microsoft 365 aka Office 365
    Posts
    3,863

    Re: Import all Userforms from a directory into active Excel Workbook?

    Hi Chris,

    The following thread from Ron de Bruin has code that will import or export UserForms, Classes, and Code modules: http://www.rondebruin.nl/win/s9/win002.htm

    There are prerequisites mentioned in the thread that are REQUIRED.

    For anyone interested in additional VBE programming information, there is a wealth of information and example courtesy of Chip Pearson at: http://www.cpearson.com/Excel/VBE.aspx

    Lewis
    Last edited by LJMetzger; 02-17-2015 at 07:32 AM. Reason: Corrected wrong link - complete rewrite - Thank you Mike

  3. #3
    Forum Expert mikerickson's Avatar
    Join Date
    03-30-2007
    Location
    Davis CA
    MS-Off Ver
    Excel 2011
    Posts
    6,229

    Re: Import all Userforms from a directory into active Excel Workbook?

    LJMetzger,
    your first link links back to this thread.
    _
    ...How to Cross-post politely...
    ..Wrap code by selecting the code and clicking the # or read this. Thank you.

+ 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. VBA to import directory into one active sheet
    By terdfurgeson in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-11-2014, 11:39 AM
  2. Import .csv files from workbook directory
    By desolatori in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 12-18-2013, 10:05 AM
  3. VBA: Import CSV file into an Excel Workbook with user defined file name and directory
    By LarryLegend in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-18-2012, 04:47 AM
  4. Import a macro (module) into the active Excel workbook
    By MrHockey in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-09-2010, 10:18 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