Creating Document Based Load Files from Page Based Load Files

Do the following steps to create a document based .opt file:

• 1. In the production LOADFILES folder, locate the VOL001.lexbeloadfile.xlsx file.

     1. Create a copy of this file (by selecting it and then doing a Crtl+C followed by Crtl+V).

     2. Open the new file “VOL001.lexbeloadfile - Copy.xlsx” in Excel by double clicking on it.

  2. Delete all columns except for:

• • 1. BEGDOC

    2. PAGES

    3. VOLUME

    4. PDFPATH

• 3. The resulting Excel should look similar to this:

• 1. Add the following formula to cell E2:

=A2&","&C2&","&SUBSTITUTE(D2,"\PDF\","PDF\")&",Y,,,"&B2

• 1. Copy down the formula (by dragging the bottom right hand corner of the cell) so there is a formula for every row with data.

• 1. The resulting Excel should look similar to to this:

  2. Open a new file in NotePad. Copy and Paste the data content of the E column into this new file.

  3. The resulting NotePad should look similar to this:

    9. Save the NotePad file in the Production LOADFILES folder as VOL001.PDF.opt