+ Reply to Thread
Results 1 to 2 of 2

Excel Export/Import worksheets and code Tool

  1. #1
    Registered User
    Join Date
    01-15-2016
    Location
    New England
    MS-Off Ver
    2007
    Posts
    29

    Excel Export/Import worksheets and code Tool

    I created this XL manager class that is useful for when an excel program is available on a shared drive and users have their own local copys and there are multiple versions floating around.


    This give the developer the ability to update the code of an Excel file without changing any information saved on the sheets.

    It gives the users the ability to import and export saved sheet information without overwriting any existing sheets or code.
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    01-15-2016
    Location
    New England
    MS-Off Ver
    2007
    Posts
    29

    Re: Excel Export/Import worksheets and code Tool

    This program creates and deletes modules.

    Go to Macro trust settings and enable "Trust Access to VBA project object model" to allow it to work


    Also the passwords are defined in Class declaration.

+ 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] Import and export txt files automatically with correct name/subject code
    By Biopsy in forum Excel Programming / VBA / Macros
    Replies: 21
    Last Post: 06-06-2019, 08:50 AM
  2. How to export/import VBA code from one workbook to another?
    By jGKpZ8a33sPrnqX8fam7 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-09-2017, 01:26 PM
  3. 'Multiple Code Module Management' (Export, Import, CleanUp, etc.)
    By Warbe in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-08-2015, 06:17 PM
  4. Help write code to Import/Export worksheets
    By emptycucumber in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-03-2009, 10:54 AM
  5. Macro for Export/Import - need help revising a code
    By emptycucumber in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-29-2009, 01:27 PM
  6. [SOLVED] Import VBA Code in Excel-File ? (Export VBA Code to file)
    By Matthias Pospiech in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-22-2005, 01:06 PM

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