Looping for writing multiple PDF Files to Excel


#1

Hi,

when I write one pdf file to excel, there is data when I open the excel document. However, when I loop it using Assign and For Each properties, the excel document which is created has no data. How do I solve this?


#2

You are replacing the existing data in the PDF when you try to write the second time. You can solve it by writing the PDFs to different sheets in the excel. Take a variable(for eg counter) and increment it every time you loop through the PDFs and add this number to the sheetname and create a new sheet while writing into the excel.