0

I have a userform in word built over 10+ years. Today Word chose to crash the normal.docm file and the VBA project became unreadable.

I have used python scripts to extract the code, but I don't have the form.

Is there a tool available to extract the userform from vbaProject.bin ? Or do I have to go the manual way and recreate everything from ground up ?

Improve this question
4
  • 1
    The vbaProject.bin file has the Form Designer data inside. It can just be unzipped, but you probably need the whole .bin file for Word to import it as a form. Depending on how it's corrupted, you may be able to clear certain parts out and re-zip the whole thing?
    – Cpt.Whale
    Commented Feb 13 at 15:27
  • If you're really desperate, here are technical documents describing the structure of the vbaProject.bin file contents, and the Forms data itself, but it goes over my head
    – Cpt.Whale
    Commented Feb 13 at 15:28
  • 1
    For future reference: The normal template is a; very poor location to store your important vba. Consider, in the future, using a separate Global template. Also backup your work, regularly. Here are two linksw on those topics. wordmvp.com/FAQs/MacrosVBA/OrganizeMacros.htm
    – Charles Kenyon
    Commented Feb 13 at 21:25
  • @CharlesKenyon thank you for your suggestion and link. Did much reading up on how to do things, and will redo the project the "right way" using global templates.
    – MyICQ
    Commented Feb 14 at 12:08

0

Reset to default

You must log in to answer this question.

Browse other questions tagged .