Home

Excel sheet with coding not working

%3CLINGO-SUB%20id%3D%22lingo-sub-328582%22%20slang%3D%22en-US%22%3EExcel%20sheet%20with%20coding%20not%20working%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-328582%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20this%20excel%20drawing%20register%20which%20has%20been%20coded%20using%20Visual%20Basic%20however%20I%20have%20no%20idea%20about%20coding.%20When%20I%20open%20the%20sheet%20I%20immedietly%20get%20an%20error%20when%20clicking%20anywhere%20referencing%20an%20error%20in%20the%20code.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDoes%20anyone%20know%20how%20to%20solve%20this%20issue%2C%20the%20file%20is%20attached.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-328582%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-507704%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20sheet%20with%20coding%20not%20working%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-507704%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F22322%22%20target%3D%22_blank%22%3E%40Jan%20Karel%20Pieterse%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHow%20will%20this%20alter%20the%20code%20in%20VBA%3F%20The%20worksheet%20doesn't%20work%20and%20it%20keep%20highlighting%20the%20attached.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20guessing%20I%20need%20to%20edit%20that%20bit%20to%20reflect%20what%20you%20posted%3F%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20594px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F111347i74D7D110E1E83D3F%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Capture.PNG%22%20title%3D%22Capture.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CBLOCKQUOTE%3E%3CHR%20%2F%3E%3CHR%20%2F%3E%3C%2FBLOCKQUOTE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-330069%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20sheet%20with%20coding%20not%20working%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-330069%22%20slang%3D%22en-US%22%3E%3CP%3EYour%20best%20bet%20would%20be%20to%20make%20sure%20the%20file%20does%20not%20use%20these%20controls%20to%20begin%20with.%20Both%20are%20part%20of%20an%20external%20library%20which%20is%20no%20longer%20part%20of%20the%20default%20Windows%20installation.%20Also%2C%20you%20will%20have%20to%20make%20sure%20every%20computer%20which%20needs%20to%20use%20this%20Excel%20file%20will%20have%20to%20be%20updated%20to%20include%20both%20ocx%20files.%20I%20can%20see%20in%20the%20code%20that%20the%20common%20controls%20library%20is%20there%20because%20the%20programmeer%20added%20a%20date%20picker%20control%20to%20the%20VBA.%20This%20can%20be%20replaced%20with%20a%20version%20which%20does%20not%20use%20any%20external%20libraries%2C%20as%20demonstrated%20here%3A%26nbsp%3B%3CFONT%20style%3D%22background-color%3A%20%23ffffff%3B%22%3E%3CA%20href%3D%22http%3A%2F%2Fwww.rondebruin.nl%2Fwin%2Faddins%2Fdatepicker.htm%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttp%3A%2F%2Fwww.rondebruin.nl%2Fwin%2Faddins%2Fdatepicker.htm%3C%2FA%3E%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-329837%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20sheet%20with%20coding%20not%20working%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-329837%22%20slang%3D%22en-US%22%3E%3CP%3EThanks.%20Any%20ideas%20if%20it%20can%20be%20fixed%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-329730%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20sheet%20with%20coding%20not%20working%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-329730%22%20slang%3D%22en-US%22%3EThe%20VBA%20code%20complains%20about%20two%20system%20files%20which%20are%20not%20on%20your%20system%20(probably%20because%20they%20are%20no%20longer%20part%20of%20Windows)%3A%3CBR%20%2F%3Ec%3A%5CWindows%5CSysWOW64%5Cmsmask32.ocx%3CBR%20%2F%3Eand%3CBR%20%2F%3Ec%3A%5CWindows%5CSysWOW64%5Cmscomct2.ocx%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-511028%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20sheet%20with%20coding%20not%20working%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-511028%22%20slang%3D%22en-US%22%3EThe%20page%20I%20linked%20to%20has%20some%20instructions%20how%20to%20use%20it.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-511271%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20sheet%20with%20coding%20not%20working%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-511271%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F22322%22%20target%3D%22_blank%22%3E%40Jan%20Karel%20Pieterse%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20tried%20to%20follow%20those%20but%20not%20sure%20how%20to%20replace%20the%20existing%20code%20with%20what%20is%20suggested.%20I%20don't%20think%20it%20is%20like%20for%20like%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHopefully%20if%20I%20manage%20to%20sort%20that%20then%20the%20spreadsheet%20will%20work.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
az123330
Occasional Contributor

I have this excel drawing register which has been coded using Visual Basic however I have no idea about coding. When I open the sheet I immedietly get an error when clicking anywhere referencing an error in the code.

 

Does anyone know how to solve this issue, the file is attached. 

6 Replies
The VBA code complains about two system files which are not on your system (probably because they are no longer part of Windows):
c:\Windows\SysWOW64\msmask32.ocx
and
c:\Windows\SysWOW64\mscomct2.ocx

Thanks. Any ideas if it can be fixed?

Your best bet would be to make sure the file does not use these controls to begin with. Both are part of an external library which is no longer part of the default Windows installation. Also, you will have to make sure every computer which needs to use this Excel file will have to be updated to include both ocx files. I can see in the code that the common controls library is there because the programmeer added a date picker control to the VBA. This can be replaced with a version which does not use any external libraries, as demonstrated here: http://www.rondebruin.nl/win/addins/datepicker.htm

@Jan Karel Pieterse 

 

How will this alter the code in VBA? The worksheet doesn't work and it keep highlighting the attached.

 

I am guessing I need to edit that bit to reflect what you posted?Capture.PNG



 

 

The page I linked to has some instructions how to use it.

@Jan Karel Pieterse 

 

I have tried to follow those but not sure how to replace the existing code with what is suggested. I don't think it is like for like?

 

Hopefully if I manage to sort that then the spreadsheet will work. 

Related Conversations
Extentions Synchronization
Deleted in Discussions on
3 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
9 Replies