Hey guys,

Stumbled across this site while looking for an answer to this issue. Wish I knew about this forum a month ago while I was learning! You guys are amazing and the forums are full of knowledge. Wondering if you could help me out.

I'm making a macro to to automate a few processes and then save everything so templates stop getting saved over (and formula's lost) in Excel. I'm using VBA 6.5.

What I am trying to do is copy an embedded word object on Sheet 1 over to the top of Sheet 2. I have tried everything to do this but the Object always has a different name. Copying all cells around it (which works with a right click) doesn't work in VBA. The formula in the sheet is =EMBED("Word.Document.8",""). I don't create the sheet (only the one that is using this information) so I can't create a naming convention or copy contents into Excel, etc. Any idea how to do this in VBA?

Thank you in advance for your help.
-Scott