Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to Export all Macros & Forms from vba project.
On Jul 27, 1:54*pm, "macropod" wrote:
Hi Shazi, You might want to try this first:http://support.microsoft.com/kb/264907 -- Cheers macropod [MVP - Microsoft Word] "Shazi" wrote in ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Microsoft Project Export to Excel | Excel Discussion (Misc queries) | |||
Export from MS Project to excel along with Gant Chart | Excel Discussion (Misc queries) | |||
Project - Forms Data Compilation | Excel Discussion (Misc queries) | |||
Is there a way to export excel data into MS project? | Excel Discussion (Misc queries) | |||
Export to MS Project | Excel Programming |