How to make Excel macro splitting file into several in silent mode?

Asked Jun 28 '16 at 18:51

Active Jun 28 '16 at 18:53

Viewed 347 times

For splitting a file into several files by unique names in certain column I used a wonderful VBA snippet from this answer.

I've added some code to achieve required functionality like replacing .SpecialCells to .EntireRow and adding multiple filters to meet all possible cases in that task of splitting.

However, I've found that after linking this snippet to UserForm via button, Excel's starting blinking and filtering as the snippet works in real time. I have to split an Excel file into several hundreds, and it is rather complicated task in terms of PC's perfomance.

The question is "Are there any VBA or Excel settings to run VBA snippets silently without GUI events?". I hope the nature of my question is clear.

edited May 23 '17 at 11:58

Community

asked Jun 28 '16 at 18:51

aestet

4

`application.screenupdating=false` – findwindow Jun 28 '16 at 18:52
Indeed, application.screenupdating=false is the way to go – Absinthe Jun 28 '16 at 18:54
@findwindow thank you! – aestet Jun 28 '16 at 18:54
2

remember to add `application.screenupdating=true` at the end. Or your excel will seem dead. – Aganju Jun 28 '16 at 19:03
@Aganju - `Screenupdating` is automatically reset as soon as your code is done executing... – Tim Williams Jun 28 '16 at 19:12
just as a note - its not silent, that instance of excel will still hang while its running and will not be usable until the code is complete. – Steven Martin Jun 28 '16 at 19:15
OT: You may want to read to [this](http://datapigtechnologies.com/blog/index.php/ten-things-you-can-do-to-speed-up-your-excel-vba-code/) or [this](http://www.ozgrid.com/VBA/SpeedingUpVBACode.htm) to understand how to speed up code in Excel and avoid some events – Sgdva Jun 28 '16 at 20:39

How to make Excel macro splitting file into several in silent mode?

0 Answers0