-
Aug 14th, 2008, 08:17 AM
#1
Thread Starter
New Member
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
-
Aug 14th, 2008, 11:39 AM
#2
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!
• Reps & Rating Posts • VS.NET on Vista • Multiple .NET Framework Versions • 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 i7 6850K, Geforce GTX1060, Samsung M.2 1 TB & SATA 500 GB, 32 GBs DDR4 3300 Quad Channel RAM, 2 Viewsonic 24" LCDs, Windows 10, Office 2016, VS 2019, VB6 SP6
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|