VBA to Browse insert an Object in excel in specific cell

  • Hi,

    I am looking for an VBA code to browse and insert an object in a specific cell as follows in the attached excel.

    1.If i click browse G3, it shoud open a file explorer to choose a file.

    2. Then if i select a file and attach, it shoud attach in cell F3 in centre.

    3.The attached file should be with the same name of the file and with the same icon (For Eg.If the attached filr is PDF, then the icon shold be PDF, if fie is excel then the file icon should be excel and so on)

    4.In the same way if i browse G4, file should be attached in F4 and so on.

    Experts, pls help to create a VBA code in the attached Excel.

  • Hello,

    I tried using your code and it works well. One thing that I would like it to do for me is just show as an Icon of about 1.5cm x 1.5cm in size instead of showing the whole document. When the icon is then clicked for it open up an embeded file (e.g. pdf or jpg).

    Would you be so kind as to show me the alternative code for this.

    Thank you very much

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!