Speed up process?

[vbNeo]

Is it possible to speed up a process I'm doing in word? I've written a function that loads a file line by line, creates a new row in my table, and inserts data from the file accordingly - this works fine, but I have 2000 entries, and since Word shows everything(tables being made, etc.) it's slower for every page of rows that's added, so when it comes to a 1000 it's reeaalllyyy slow - can I hide it in any way ?

Cheers!

[si_the_geek]

Your process could be made faster (by loading the whole file at once for example), if you want help there let us know.

For the main issue just do this:

Application.ScreenUpdating = False


and when you finish (or have an error, or show a message to the user) you must do this:

Application.ScreenUpdating = True

(otherwise you wont see anything in Word even if you close & re-open it )

[vbNeo]

Originally posted by si_the_geek
Your process could be made faster (by loading the whole file at once for example), if you want help there let us know.

For the main issue just do this:

Application.ScreenUpdating = False


and when you finish (or have an error, or show a message to the user) you must do this:

Application.ScreenUpdating = True

(otherwise you wont see anything in Word even if you close & re-open it )

Ahh, k, Thanks ! - And yeah, I could load the file first and do a split on vbCrLf, good idea!

Cheers!

[si_the_geek]

Originally posted by vbNeo
Ahh, k, Thanks ! - And yeah, I could load the file first and do a split on vbCrLf, good idea!

Cheers!

no worries.