View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Shazi Shazi is offline
external usenet poster
 
Posts: 74
Default How to Export all Macros & Forms from vba project.

Hi,

I prepared a VBA Project, now its finalized, but I think the size is
too big, 14 userforms and 11 macro modules are included.

now I want to export all forms and macros, I can do it one by one, but
I need a macro who export every thing outside the project to C:\Forms-
Macros directory.

then I will check the file size of my project, and do some necessary
actions to reduce the size, its 1 mb now. it should be 0.5 mb I
think.

With best regards.

shahzad