Thread: End user to attach a PDF for review

i want to be able to send an excel sheet to my collegues to input some data and return to me, i have already managed to steal code from the VB help to enable them to press a button and return the file to me (review file script) or something, if i can just allow my collegues to attach a pdf to the excel sheet by simply dragging and dropping or inserting a browse file function to the sheet i will have completed my task.

anyone tell me how to do this (Spent only 2 years on basic VB at College) and that was 9 yrs ago so go easy!!

Ive had no suggestions so let me explain further.

In my job i need to send a customer capture sheet to my reps to complete and return to me as an attachment, they also need to send me a pdf with the details of the order.

i have set up a capture sheet in Excel have added some vb code to a macro to enable them to left click a submit button which returns the completed form directly to my email account, however they still need compile a new email and attach the pdf and then send that to me also.

i want to make this as simple as possible and allow them do everything on the excel sheet.

IS this possible????