View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
macropod[_2_] macropod[_2_] is offline
external usenet poster
 
Posts: 293
Default How to Export all Macros & Forms from vba project.

Hi Shazi,

You might want to try this first:
http://support.microsoft.com/kb/264907

--
Cheers
macropod
[MVP - Microsoft Word]


"Shazi" wrote in message ...
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