Catching DoEvents in excel vba

Asked Mar 17 '23 at 19:18

Active Mar 17 '23 at 19:20

Viewed 73 times

I'm writing excel/vba to read a word file and parse through the contents, creating a CSV file from those contents.

I have a loop that looks like this:

with doc
    for each para in doc.paragraphs
        DoEvents
        txt = trim(para.range.text)
        debug.print txt
    next 
end with

More code will be forthcoming as I figure this out. However, I have encountered a problem when I click the stop button in the developer ribbon - the doevents does catch it and stop running. However, the windows file is still open and it causes an error for the next time around. Is there a way to catch the doevents and have it close all the other open files?

edited Mar 17 '23 at 19:20

Scott Craner

148,073
10
49
81

asked Mar 17 '23 at 19:18

elbillaf

1,952
10
37
73

2

You would "catch DoEvents" as soon as you moved the mouse one pixel. So thankfully, no. – GSerg Mar 17 '23 at 19:29
2

Maybe look at: https://learn.microsoft.com/en-us/office/vba/api/excel.application.enablecancelkey (for use with Esc) – Tim Williams Mar 17 '23 at 19:46
Ah, yes, that looks like the right way to do it. I was heading down the wrong path. tx – elbillaf Mar 17 '23 at 20:05

Catching DoEvents in excel vba

0 Answers0