+ Reply to Thread
Results 1 to 3 of 3

How to export all the vb modules in an excel file at one shot

  1. #1
    Registered User
    Join Date
    09-20-2016
    Location
    Bangalore
    MS-Off Ver
    2013
    Posts
    32

    How to export all the vb modules in an excel file at one shot

    someone kindly assist me to export all the macros available in the excel file at one shot.

  2. #2
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,620

    Re: How to export all the vb modules in an excel file at one shot

    HAve you tried for instance: http://www.rondebruin.nl/win/s9/win002.htm
    note 2 important points: references in VBeditor - tools - references
    Trust access to the Visual Basic Project setting must be anabled
    Best Regards,

    Kaper

  3. #3
    Registered User
    Join Date
    09-20-2016
    Location
    Bangalore
    MS-Off Ver
    2013
    Posts
    32

    Re: How to export all the vb modules in an excel file at one shot

    Hi Mr. Kaper,

    Thanks for the info. It works...

+ 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. Export Excel records to seperate text file & compress it to protecte ZIP file
    By firedragon in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-03-2012, 10:47 AM
  2. Replies: 1
    Last Post: 12-02-2007, 05:52 AM
  3. [SOLVED] Export modules from protected projects
    By Frederick Chow in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-16-2006, 05:10 PM
  4. Export modules from protected projects
    By Frederick Chow in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-21-2006, 01:10 PM
  5. [SOLVED] auto-export VBA modules
    By Christopher Merrill in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-20-2005, 02:05 PM
  6. Export excel file to semicolon delimited text file
    By capitan in forum Excel General
    Replies: 5
    Last Post: 04-06-2005, 11:07 PM
  7. Export excel file to semicolon delimited text file
    By capitan in forum Excel General
    Replies: 5
    Last Post: 04-06-2005, 11:07 PM
  8. [SOLVED] Excel should export its file as exe
    By Rashid in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-06-2005, 08:06 AM

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