Needs Help With Editing Upload Cell

If it's a hyperlink to the file then

Please Login or Register  to view this content.

In that case then just start the macro with Range("B17").Select

Just out of interest, what's the essential difference/advantage that an embedded object rather than a hyperlink gives you?

Originally Posted by ham123

It's because someone else has to submit a form which is the excel spreadsheet I am preparing. They need to embed it, if not I won't receive anything.

Hi,
What do you mean by you won't receive it?
Embedding it as an object doesn't mean you have 'received' anything. All you have is an object which when clicked opens the other workbook - exactly the same functionality as a hyperlink. It just seems a rather unusual way to do it that's all.

The other option of course would be to create a workbook save event macro in the other workbook so that when the someone else saves the workbook a copy is automatically emailed to you.

You are already doing that. I don't therefore understand your question.

And if you start the macro with the Range("B17").Select it will embed the object in the B17 cell

Perhaps it would help if you explain what you then do with the embedded object. You've previously talked about wanting to 'receive' it.

I suspect that what you want to see is the data from that other workbook IN YOUR workbook, and if that's the case then you need to open the workbook, copy the data and paste it into your workbook.