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.

 

[Logit]

You can post the workbook to a download site (DropBox.com, etc) then provide the link here.

 

[Nour]

link to dropbox for file Patient register UC.xlsb password for all users is letter a

 

[Nour]

You can post the workbook to a download site (DropBox.com, etc) then provide the link here.

Patient register UC.xlsb file link in dropbox

 

[Nour]

link to dropbox for file Patient register UC.xlsb password for all users is letter a

Patient register UC.xlsb earlier one was wrong link

 

[Logit]

I tried to load your workbook and receive an error message re: missing the following library :

Additionally, when first loading your workbook it is asking me for a password to the VBE. I tried the letter "a" but that didn't work.
The initial error message displayed when first opening the workbook basically says .... "There is an error on Sheet X. Do you want to continue ?" The
letter X refers to a tab number. Here, the errors go through all the sheets of the workbook.

At this point my only recommendation is to start fresh. Create a new workbook ... then manually re-enter everything into this new workbook - both the macros and
the sheet layouts. Do not copy and paste because you will inevitably copy something that is corrupted and paste it into the new workbook.

Sorry for this realization.

After creating the new workbook and verifying it works as desired ... create a clean copy and store it somewhere safe for possible future use. Regretfully I've had to
do this same thing on a few of my projects.

 

[Nour]

I tried to load your workbook and receive an error message re: missing the following library :

View attachment 99935






Additionally, when first loading your workbook it is asking me for a password to the VBE. I tried the letter "a" but that didn't work.
The initial error message displayed when first opening the workbook basically says .... "There is an error on Sheet X. Do you want to continue ?" The
letter X refers to a tab number. Here, the errors go through all the sheets of the workbook.

At this point my only recommendation is to start fresh. Create a new workbook ... then manually re-enter everything into this new workbook - both the macros and
the sheet layouts. Do not copy and paste because you will inevitably copy something that is corrupted and paste it into the new workbook.

Sorry for this realization.

After creating the new workbook and verifying it works as desired ... create a clean copy and store it somewhere safe for possible future use. Regretfully I've had to
do this same thing on a few of my projects.

I am sorry for the password issue. I realised like I sent one of the ones I was trouble shooting. I have never gotten any error. I will upload a cleaner version. The missing library, you have to install by doing to tools, references and Microsoft Windows common controls 6.x(sp6). It will be there if you have installed mscomctl.ocx to your office. I have recorded a video to show you the exact problem. Will send the link shortly. Thank you very much for the concern.

 

[Nour]

merged video_1.mp4 for video description of problem
Patient register UCold.xlsb an earlier copy before my changes
Patient register UC.xlsb file with the problem
MSCOMCT2.zip library reference add-in
Also if you are not using 32bit version of office, please delete an reference to modal and modeless in the vba or else it will describe it as error as 64bit does not recognise the function............
Private Declare Function EnableWindow Lib "user32.dll" (ByVal hWnd As Long, ByVal fEnable As Long) As Long, EnableWindow Application.hWnd, Modeless and Const Modal = 0, Modeless = 1

 

[Logit]

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.

 

[rlv01]

link to dropbox for file Patient register UC.xlsb password for all users is letter a

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

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

 

[rlv01]

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