How to Export all Macros & Forms from vba project.

[Shazi]

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

 

[macropod]

Hi Shazi,

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

 

[Shazi]

Hi Shazi,

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

--
Cheers
macropod
[MVP - Microsoft Word]

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- Hide quoted text -

- Show quoted text -

Hi,
Cheers

Thank you for your support and prompt reply.

Regards.

Shahzad