Home > Forum Home > Developing Business Administration Solutions > Importing Data from PDF Files > Holding found text instances in memory Share

Holding found text instances in memory

Excel Help for Holding Found Text Instances In Memory in Developing Business Administration Solutions


Forum TopicLogin

Holding Found Text Instances In Memory

Rate this:
(3/5 from 1 vote)
OopsThis is definitely something that would be good to add to the code as an option. At the moment, the last instance is returned as the result.  The code loops through each line of the text content of the PDF looking for the start pattern and end pattern and saving the part in between in memory. The prt of code in the Run_Extraction() routine that gets the text is right before the end of the loop as:

VBA Code:
'test if in text gathering blCont and append
If blCont = True And strTemp <> "" And Not strLine Like "*" & cs & "*" Then
        strTemp = strTemp & Chr(10) & Trim(strLine)
End If

This needs to be modified with another variable to hold what was previously found and appended to the overall result.
 Excel Business Forums Administrator
 Posted by on
 
View Full Post

Find relevant Excel templates and add-ins for Holding found text instances in memory in the