Acrobat Pro DC becomes "Not Responding"

Question

Hi.I am finding the word I want using Excel VBA.There are about 530 pages in my PDF file.After processing about 400 pages, the error message "Microsoft Excel is waiting for another application to complete an OLE action. " always displayed from Excel, and Acrobat becomes "Not Responding".  lRet = objAcroAVDoc.Open(PDFPath, "")
  lRet = objAcroApp.Show
  Set objAcroPDDoc = objAcroAVDoc.GetPDDoc()
  Set jso = objAcroPDDoc.GetJSObject

pageNum = objAcroPDDoc.GetNumPages()
  For i = 0 To pageNum - 1
    wordNum = jso.getPageNumWords(i)
    For j = 0 To wordNum - 1
      wordStr = jso.getPageNthWord(i, j, False)
      If wordStr = MyFindWord Then
	' Do some processing
      end if
    next
  nextMy PC : Windows11Acrobat Pro Version:  2024.002.21005 64bitExcel : 365 I tried the following, but it didn't change anything.1. Reinstall Acrobat2. Repair Acrobat3. Restart my PC4. Turn off "Enable Protected Mode at startup" and "Enable Enhanced Security"5. Delete thumbnails in C:\Users\User name\AppData\LocalLow\Adobe\Acrobat\DC\ConnectorIconsPlease give me some advice.

BarlaeDC · Answer

Hi,

Can I check that that is the complete code? if it is then it might be worth adding code in to set all the variables to nothing when you are done with them.

 lRet = objAcroAVDoc.Open(PDFPath, "")
  lRet = objAcroApp.Show
  Set objAcroPDDoc = objAcroAVDoc.GetPDDoc()
  Set jso = objAcroPDDoc.GetJSObject

  pageNum = objAcroPDDoc.GetNumPages()
  For i = 0 To pageNum - 1
    wordNum = jso.getPageNumWords(i)
    For j = 0 To wordNum - 1
      wordStr = jso.getPageNthWord(i, j, False)
      If wordStr = MyFindWord Then
	' Do some processing
      end if
      set wordString = Nothing
    next
    set wordNum = Nothing
  next
set pageNum = Nothing

Acrobat and Excel don't seem to handle their objects very well, so you may just be running out of memory.

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded