Home > Forum Home > Developing Business Administration Solutions > Importing Data from PDF Files > Confused Share

Confused

Excel Help for Confused in Developing Business Administration Solutions


Forum TopicLogin

Confused

Rate this:
(3/5 from 1 vote)
Confused In my opinion that is what its not doing.

This excel VBA code or the pdftotext.exe doesnt know how to not overwrite cells that have data on it. It doesnt matter if the code to delete the data is commented out because every time the program simply starts from the beginning, it reads every PDF file from the beginning, that is intended, but at the same time it overwrites the old data because it was not programmed to resume writing from the first empty cell.

While running the extraction command it knows how to copy data of each pdf file to a new row, but after the extraction process is over it forgets where it left. Next time you run the extraction, it starts from the beginning of the sheet overwriting the old data. That is how it runs because it was intended that way.

I have tried to change the mrow variable VBA code so that it would find the first empty cell, but every time I have run errors on the following command line and that is where I drop off.

VBA Code:
Call Run_Replacements(CStr(Cells(mrow, (j + 3)).Address), CStr(arrTmp(j, 2)))
 Posted by on
 
View Full Post

Find relevant Excel templates and add-ins for Confused in the