EXCEL VBA - export a group of modules to .bas files-VBForums
Results 1 to 2 of 2

Thread: EXCEL VBA - export a group of modules to .bas files

  1. #1

    Thread Starter
    New Member
    Join Date
    Aug 2008
    Posts
    2

    EXCEL VBA - export a group of modules to .bas files

    hi,

    i'm working with VBA in excel. i have about 15 modules. periodically i export them to .bas files as backup and import to any other project.

    i can export them, one by one
    select module -> right click -> export -> ...

    it doesn't allow to select all modules at the same time

    how i can do this more friendly? some macro? any other way?

    at the end i want to have a set of ascii .bas files saved in the hd

    tks in advance

  2. #2
    Super Moderator RobDog888's Avatar
    Join Date
    Apr 2001
    Location
    LA, Calif. Raiders #1 AKA:Gangsta Yoda™
    Posts
    60,100

    Re: EXCEL VBA - export a group of modules to .bas files

    You can write code to automate the export process.

    Check out this CodeBank entry on how to access the modules. It should give you some direction on what you want to do.

    http://www.vbforums.com/showthread.php?t=313861
    VB/Office Guru™ (AKA: Gangsta Yoda®)
    I dont answer coding questions via PM. Please post a thread in the appropriate forum.

    Microsoft MVP 2006-2011
    Office Development FAQ (C#, VB.NET, VB 6, VBA)
    Senior Jedi Software Engineer MCP (VB 6 & .NET), BSEE, CET
    If a post has helped you then Please Rate it!
    Star Wars Gangsta Rap Reps & Rating PostsVS.NET on Vista Multiple .NET Framework Versions Office Primary Interop AssembliesVB/Office Guru™ Word SpellChecker™.NETVB/Office Guru™ Word SpellChecker™ VB6VB.NET Attributes Ex.Outlook Global Address ListAPI Viewer utility.NET API Viewer Utility
    System: Intel Core 2 Extreme Ed., 2 WD Raptor 10K RPM 300 GB HDs, 2 GBs DDR2 667 MHz RAM, 2 Viewsonic 24" LCDs, Windows 7 SP-1/Windows 8.1, Office 2010, VS 2013

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Featured


Click Here to Expand Forum to Full Width

Survey posted by VBForums.