word macros excel

Public Schedule Face-to-Face & Virtual Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Word Training and help » Word macros excel

Word macros excel

resolvedResolved · Urgent Priority · Version 2016

Word macros excel

Hi


I have recently started a new project that involves preparation of financial statements/accounts using a Word template file. The word file has embedded macros that I need to run in order to import the information from Excel tables.

The files are under Microsoft 2016.
I have no experience in VBA/macros etc , but I can say for sure that something is not right as these files are terribly slow to open and operate, crashing every so often, if I manage to open them.

What should be a starting point for me to understand the issue and resolve/ speed up the process ?
Thank you in advance
Gabriela

RE: 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

Will be marked as resolved in 5 days

Notice: This is an automated message. Due to inactivity, this forum post will be marked as 'resolved' if there are no further responses in the next 5 days.

Fri 15 Nov 2019: Automatically marked as resolved.

 

Training courses

 

Training information:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

Word tip:

Change the default font in Word

The default settings for all new documents created in Word are stored in the Normal template, Normal.dot.

To change the font for the Normal template, start a new document then go to Format - Font.

Change the font settings to reflect the font and font size you would like to use in future in most or all of your documents.

Click the Default button in the bottom left-hand corner of the Font dialogue box. Click Yes when the message associated with the font change appears on your screen.

You have now changed the default font for all new documents created from this point forward.

View all Word hints and tips


Server loaded in 0.08 secs.