Insert Object through Hyperlink

[KKR1975]

Seeking some on help.

I have hypherlinks in my active workbook Say column F.

I am using the below code to insert multiple objects in my active work book. This code will browse for select files to insert object. Instead of browse, the code need to open each hypherlink and then need to insert. (Instead browse for path, the code need to use Hypherlink available in active worksheet)

seeking some one help to modify the code.

Please Login or Register  to view this content.

[davesexcel]

Just to be clear,
you have a hyperlink that contains a picture file name and you want to insert this picture into the worksheet?

[KKR1975]

Hi DaveExcel

I have hyperlink of all file type. outlook message files, excel file, picture and pdf

[davesexcel]

Still unsure what you are asking.

[KKR1975]

Hi

In my excel workbook, column F I have hyperlink
Ex In row 1 to 50 ( F1 to F50) each hyperlink having different file types but all files are in C drive

I need macro to open one by one link and save some temporary folder then each files to be inserted as object in next column ex H1 to H50

In other words, hyperlink files to be inserted as object on the same workbook

[davesexcel]

You may have to supply a sample workbook showing the results you are looking for.

[KKR1975]

Hi davesexcel

Sample Work Book attached for your reference

[davesexcel]

I don't think you can do what you are trying to do.
You can't embed files onto a spreadsheet.

[KKR1975]

Hi

The below code i am using embed files on spread sheet. The code is working fine.

My current requirement is that, the code is browse folder to select the embed files, instead of that i am expecting to use the hypherlink path (WHICH IS AVAILABLE IN MY WORKSHEET)for each row to embed the files on spread sheet. I am expecting someone help to modify the code accordingly. Particularly on the highlighted line of the code

Please Login or Register  to view this content.

[KKR1975]

Hi anyone please help me

[Dante Amor]

Try this:

Please Login or Register  to view this content.

[KKR1975]

Hi Dante Amor

Thank you so much for your help. Code is working perfectly as expected

[Dante Amor]

I'm glad to help you. Thanks for the feedback.