Insert File into Excel as Icon

[Abhishek1988]

Hi Everyone,

I have a button and i need help to apply a macro on this button with following output.

1. Motive of this button is to insert document into excel as an icon

2. Document path should be based on A1 (Drive Location) + file name mentioned in code (.pdf)

3. Document caption should be defined in Code.

4. Cell location should also defined in code

Please help me with this. let me know if you need any information around this

Thanks

 

[John_w]

See if you can adapt the code at https://www.mrexcel.com/forum/excel...con-defined-cell-post4961840.html#post4961840

 

[Abhishek1988]

thanks for response, i will look into this. Can you please tell me how can i active such SUB on button click?

 

[John_w]

Just assign the macro, Insert_File_With_Icon, to the button (form control).