I have a worksheet that reads data from a lookup table ... it then needs to
create a pdf file with a specific name based on data that is read from the
lookup table. This process would then continue until all lookup values are
exhausted.

How do I pass the correct filename onto Acrobat 6.0 so this worksheet would
not require any user input on the filenames? I know how to assemble the
filename but am having problems passing it to Acrobat.

Thanks!