0

Dearl all, I create lost of reports from a word docm template that contains also embed excel objects.

I usually hand out the pdf documents but i am forced to send docx files to certain recipients.

Inside my docm file i have lots of macoors and embeded xslx (excel) files which contain alot of calculations and forumlae which i do not want to broadcast. When i export to pdf this is a non issue. If i save my docm file as docx the macros are gone, but the the embeded excel files still contain all my formulas.

Is it possible to save my word file and convert all embeded xlsx files such that only the values (plain text) is left in the excel objects while keeping my formarting of talbes?

I do not want do do it manually as it is explained here!

Thanky you in advance.

EDIT:

I want the excel file to not contain any of the formulae , but only the plain text such as if i would have pasted it as "only values" if that makes any sense. Another obtion would be to replace embed objcts by a picture. But this usually messes up the formatiing.

1 Answer 1

0

Extracting embedded objects from Office documents is done this way:

  • Rename the extension of the document to .zip
  • Extract the contents of the Zip file
  • The embedded objects are found in the folder word, sub-folder media.

For more detailed infor mation with screenshots see the article
How to Extract Images, Text, and Embedded Files from Word, Excel, and PowerPoint Documents.

1
  • I do not want to extrakt the data, i want the excel file to not contain any of the formulae , but only the plain text such as if i would have pasted it as "only values" if that makes any sense. Another obtion would be to replace embed objcts by a picture. But this usually messes up the formatiing.
    – NorrinRadd
    Oct 8, 2019 at 14:49

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .