Ok, I will attach the documents I am working. First Attachment is the AutoCAD drawing that I will be trying to insert all the tables from the excel doc into. Second is the actual excel document that I am currently trying to have my Code as for a tool number and insert it into the "UserInput Box". I will also attach my current code. This only error it is having right now is with the line that is suppose to input the inputbox's toolnumber into excel.

ok...how do I attach an excel doc and a autocad drawing?