Hello guys.
I dont know does this question make sense or not. But i think its free to ask. So here it is.
Everyday i will scan hundreds reports to pdf into one specific folder, and rename them in typical format of their types,serial number and operation number.
Example , Dimensionreport#sn875577457#opn8700
Then i have to update those serial number and operation number into spreadsheet manually. This process will be really time consuming.So my question is, is it possible to have any macro or formula that can automatically update every new pdf files details ( serial & opn number) into spreadsheet ? Can we do that way or any better options?
Thanks in advance for helping.
Bookmarks