Upgrading office 2003 to 2013

Hi guys

My company has finally come out of the stoneage and has upgraded to 2013 from office 2003. I have this huge spreadsheet I've built over the years with loads of VBA code with help from generous people from here. I have copied all the code to a word document as the excel sheet is too large to upload. My question is, is there different code for 2013 then there is for 2003. Can anyone see any improvments in theis existing code that I can now do on 2013. In particular the code on sheet number 2 has gone very slow and is flicking screens when executing the macro. Appreciate any help on this.

Also does anyone one know where I can purchase and download office 2013 for my home laptop. ive been using 2003 at home because everything I do I use in work but now we have upgraded I would like to upgrade my home one, but I cannot seem to find anywhere online I can download 2013.

Thanks a mil.

Mr. Nitro,

Good morning!! Not sure if this is different from 2003 or not, but there are some tools that will help to speed up some calculations. For instance, at the start of your sub use this:

Please Login or Register  to view this content.

And at the end of your code use this:

Please Login or Register  to view this content.

What this does is turn off screen updating, which is what makes your screen flicker while the macro is running until the macro is finished and then the screen will update. It also turns off automatic calculation which means that the macro will not calculate the sheet every single time the macro adds something new to the sheet. Instead, it will wait until the macro is completely finished running, and then calculate the sheet. These two things should help a bit.

Dome

Hi Dome,

Thanks for the reply. Apologies for the delay in replying, literally just getting a chance to try this now. I just stuck it here. Is that right? It seems to have worked, just want to make sure it won't cause problems later on.

Please Login or Register  to view this content.

Hi Nitro

make sure you turn them back on later on in the macro before exiting the procedure

Hi Nigel,

I had that in beacuse I thought that was easy as he had said at the end of my code, but it was causing problems so i have moved the end bit up to just after that bit of code. Can you confirm I've done this right? After the End if or before the end if?

Please Login or Register  to view this content.