Opening and Saving Enbedded Object Off

[bpkcjgorr]

Good afternoon, all!

I'm relatively new to macro development, so forgive me if this is a simple problem to solve.

I have a number of objects embedded in my spreadsheet - PowerPoint, pdf and Word files. When the user opens them, I want to be sure that they cannot save anything they enter back into the workbook. It would also be nice if the opened file were displayed and ready for editing. What's the best way to go about doing that?

I've built a macro that opens the file, but when the user uses "Save As...", saves the file to the desktop and makes edits, the edits are saved back into the workbook as well.

Here is a sample of the macro that opens and displays the file:

Please Login or Register  to view this content.

Thanks -

bpkcjgorr