Corrupt VBA file on save

[Nour]

I have this macro application for POS and clinic register. However I just made some addition to the macro to increase the functionality but once it opens the first time, it refuses to open the second time and says repairing file and exit excel. My macros have no errors. In fact even the macros are not even called but the user form refuses to initialize. I need help. I have even attempted increasing the modules to 5 from 3 and but nothing works.

 

[Nour]

No it is not. "a" does not work to unlock the VBE project.

View attachment 100044

Not much point in going further with a project I cannot test or modify.

a is for login. Pls use baronious1! As password. Am really sorry for forgetting to deactivate the project password.

 

[Nour]

Since you are using 32 bit office, you should install Rob Bovey's free code cleaner and clean your code as your first step before doing anything else.

Excel VBA Code Cleaner Add-in

I use both 32 and 64 bits in the office setup. However let me use the addin and see. Am sorry have not slept well due to this issue.

 

[Nour]

I guess I'll have to take a step back and let someone else review your files.

The MCCOMCT2.OCX will not load on my machine because I am running Win 10 / 64 bit. That OCX is designed for 32 bit only.

I tried opening the PATIENT REGISTER UC.XLSB workbook but it defaults to an error as well saying it cannot find the OCX file.

I tried to get into the VBE to look at your code but the VBE is password protected. The letter "a" does not act as a password there.

I will greatl appreciate. I forgot about deactivating project password. its baronious1!

 

[Nour]

Goodness. I just used this and so far i have tried all the means by which it stops working but it as refused to stop working. It looks like problem solved. I will try for the twentieth time to be sure. Big tank you to everyone for the concern. Am sorry for the headache. Tank you very much.

I use both 32 and 64 bits in the office setup. However let me use the addin and see. Am sorry have not slept well due to this issue.

But were does excel store these junk codes? i ad earlier copied to text and imported but did not work until this code cleaned it up. Never knew excel vba has a mind of its own.