I am currently having problem embed an object on my workbook file. For example that on cell A2 is the value 4540003951 and macro will look for the file for it in a given path on cell A1. The problem is there is file name containing the value of A1 while the file name to be embed will be 4540003951_aaabs4qn4fru3zfimiabmfdjnijy5_data. My problem is that I have to embed a hundred of object in my file regarding of that file name.I just only want to find and embed it using macro with the 1st 10 digit I input on Cell A2 and so on. Hope you can help me with it here is my code

Please Login or Register  to view this content.