Simple VBA Macro required to split a Word document so each section is saved as a separate document
Following a mail merge, I have a docx document with 60 or so (Word) Sections and I now want to save each of the 60 sections as separate documents. I have some VBA knowledge but am struggle to find the correct object to do this.
Can anyone help with a quick bit of VBA to sort this please.
Can anyone help with a quick bit of VBA to sort this please.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
As a matter of interest why are you switching off screen updating during the loop, is that just to make it run quicker?
Hy
Application.SceenUpdating = true / false
Yes, it makes the code faster as it doesn't have to interact with the screen.
But makes sense only, if there is interaction with the sceen.
Better is allways to avoid all kind of selections as far as possible.
But don't forget to enable it at the end and also be aware, that for the case, your macro fails for any reason, the setting stays as last set.
Application.SceenUpdating = true / false
Yes, it makes the code faster as it doesn't have to interact with the screen.
But makes sense only, if there is interaction with the sceen.
Better is allways to avoid all kind of selections as far as possible.
But don't forget to enable it at the end and also be aware, that for the case, your macro fails for any reason, the setting stays as last set.
ASKER