Creating Document Based Load Files from Page Based Load Files
Do the following steps to create a document based .opt file:
In the production LOADFILES folder, locate the VOL001.lexbeloadfile.xlsx file.
Create a copy of this file (by selecting it and then doing a Crtl+C followed by Crtl+V).
Open the new file “VOL001.lexbeloadfile - Copy.xlsx” in Excel by double clicking on it.
Delete all columns except for:
The resulting Excel should look similar to this:
Add the following formula to cell E2:
Copy down the formula (by dragging the bottom right hand corner of the cell) so there is a formula for every row with data.
The resulting Excel should look similar to to this:
Open a new file in NotePad. Copy and Paste the data content of the E column into this new file.
The resulting NotePad should look similar to this:
9. Save the NotePad file in the Production LOADFILES folder as VOL001.PDF.opt