Hi all.

Developing an app where the user pulls up a userform. Inside the userform there are different line items they enter data for (5 line items). For each line item they may want to "upload" a pdf to the userform. Whats the best approach here and the most efficient? I'd prefer to have the uploaded .pdf go to a local folder, be renamed to the line item, and then anytime the user wants to view their upload inside the form, the code references the external folder and finds the .pdf.

This is because there could be thousands of .PDFs. I want something efficient. Am i asking too much?


Thanks for the help!