Forum Discussion

wim van nunspeet's avatar
wim van nunspeet
Copper Contributor
Mar 19, 2018

excel stops after microsoft update windows 10

I have a excel program and if i use the button "Onderdeel online opzoeken"  excel stops.

It works before a update from microsoft.

 

in cel E4 you must fill in 

1345925

then normally i find the component on the farnell.nl site

I use windows 10 but windows 7 is the same

 

  • Jamil's avatar
    Jamil
    Bronze Contributor
    I run the macro and it worked in my machine.

    Moreover, looking at the modules of the file you attached. It appears that most of the code were generated using macro recorder and these more than thousand lines code could be summarized in less than hundred line. there are lots of Select, Activate, Activecell are used which is not efficient, slow and prone to throw errors. you can either learn VBA to do it your self or you can hire a VBA dev for couple of hours to fix the code and make it short, fast and efficient.

Resources