ChrisF1979
02-03-2010, 05:56 AM
Dear all,
This is my first post, I would be grateful for any help.
I have written a filing macro at work (it takes emails, identifies the sender and files them appropriately in our work directory). It all works fine and I am happy with it. I am due to roll it out to my company next week (so this is very time critical)
However,
Yesterday, Outlook started repeatedly crashing while I was editing the code. I then noted that the VBAProject.OTM file had grown from 120k to 45MB. It grows everytime I save my project, even if I have not changed it.
I can reduce the size by copying out all the code into word, exporting the userforms and then reimporting all code and forms into a new project. However, the problem just starts again.
the beginning of this problem coincides fairly closely with my writing an 'install program' which replaces the users VBAproject file with my VBAproject file (and creates a backup of the original). I cant really see how this is related though.
Has anyone seen anything like this before? I really need to identify the problem quick!
This is my first post, I would be grateful for any help.
I have written a filing macro at work (it takes emails, identifies the sender and files them appropriately in our work directory). It all works fine and I am happy with it. I am due to roll it out to my company next week (so this is very time critical)
However,
Yesterday, Outlook started repeatedly crashing while I was editing the code. I then noted that the VBAProject.OTM file had grown from 120k to 45MB. It grows everytime I save my project, even if I have not changed it.
I can reduce the size by copying out all the code into word, exporting the userforms and then reimporting all code and forms into a new project. However, the problem just starts again.
the beginning of this problem coincides fairly closely with my writing an 'install program' which replaces the users VBAproject file with my VBAproject file (and creates a backup of the original). I cant really see how this is related though.
Has anyone seen anything like this before? I really need to identify the problem quick!