Aug 14th, 2008, 09:17 AM
EXCEL VBA - export a group of modules to .bas files
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
Aug 14th, 2008, 12:39 PM
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.
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 (VBA, VB 6, VB.NET, C#)
Software Engineer MCP (VB 6 & .NET), BSEE, CET
If a post has helped you then Please Rate it!
• Star Wars Gangsta Rap • Reps & Rating Posts • VS.NET on Vista (New) • Multiple .NET Framework Versions (New) • Office Primary Interop Assemblies • VB/Office Guru™ Word SpellChecker™.NET • VB/Office Guru™ Word SpellChecker™ VB6 • VB.NET Attributes Ex. • Outlook Global Address List • API Viewer utility • .NET API Viewer Utility •
System: Intel Core 2 Extreme Ed., 2 WD Raptor 10K RPM 150 GB HDs RAID 1, 2 GBs DDR2 667 MHz RAM, 3 Viewsonic 17" LCDs, Windows Vista RTM, IE 7, Office 2007