I wrote a program that opens PDF files, copies their content into Excel then closes the PDF. This program has to open over a thousand files but after the 186th file it fails to close the PDF and then crashes because I have too many files open.
I am closing Acrobat with this command.
code
SendKeys "^q"
code
I have two questions:
1) how can I tell if Acrobat is still running after I try to close it?
2) if I find that it is still open, how do I change the focus back to Acrobat to resent "^q" to it? or is there another way to close it?
I am closing Acrobat with this command.
code
SendKeys "^q"
code
I have two questions:
1) how can I tell if Acrobat is still running after I try to close it?
2) if I find that it is still open, how do I change the focus back to Acrobat to resent "^q" to it? or is there another way to close it?