VBA is crashing after about 350 pages

macropod · #4 03-06-2018, 03:41 PM

Quote:

Originally Posted by lars-daniel

Latest (and biggest) Intel i7 with latest Office still uses 1 core only, three cores (+ hyperthreading) are idling. I should better split it into single files and run in parallel

Splitting the document into multiple files won't help unless you also start multiple independent Word sessions.

Quote:

Originally Posted by lars-daniel

Oops, it doesn't work every time. I've got very much cells, which haven't get touched at all.

In that case, there's more than just -1 in the cells (e.g. some spaces). You might try changing:
Split(.Range.Text, vbCr)(0)
to:
Trim(Split(.Range.Text, vbCr)(0))

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Numbering with heading is mixed up in odd pages in regard to even pages	Baflla	Word	0	09-11-2016 05:25 AM
Multiple Master Pages dont sync with content pages	generatorjoe	Publisher	0	07-28-2016 10:12 AM
Spreadsheet keeps crashing	SavGDK	Excel	8	06-28-2016 08:27 AM
Office 2013 is crashing and renaming files when crashing	Brewski	Office	1	09-21-2015 09:04 PM
Advanced page numbering: section pages in header, document pages in footer	Albus	Word	12	12-12-2014 01:36 PM