Word macros excel

Hi Gabriela,

Thank you for the forum question.

It as a very difficult question to answer because the complexity of VBA.

It can be wrong memory management in the code. Non efficient use of loops in the code. Use of copy and paste in the code. It can be hundreds of different reasons.

You will need advanced level of VBA and experience of best practise writing VBA to analyse and optimise the code.

You will have to find the lines in the code which makes the file to crash and add timers to the code to find the lines which are time consuming.




Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector