Guest rob1 Posted April 11, 2011 Report Share Posted April 11, 2011 Hi, I was thinking of creating a macro that would run the document inspector, automatically remove all on each section (or at least certain sections) and then run the 'send as pdf' option. when ive tried to do this i just seem to get in the macro vba code references like below which just doesnt work does anyone have any ideas? ActiveDocument.Save ActiveWindow.Panes(2).Activate ActiveWindow.Panes(2).Activate ActiveWindow.Panes(2).Activate ActiveWindow.Panes(2).Activate ActiveWindow.Panes(2).Activate ActiveWindow.Panes(2).Activate ActiveWindow.Panes(2).Activate ActiveWindow.Panes(2).Activate ActiveWindow.Panes(2).Activate ActiveWindow.Panes(2).Activate ActiveDocument.ExportAsFixedFormat OutputFileName:= _ "C:\DOCUME~1\Solcase\LOCALS~1\Temp\test.pdf", ExportFormat:= _ wdExportFormatPDF, OpenAfterExport:=False, OptimizeFor:= _ wdExportOptimizeForPrint, Range:=wdExportAllDocument, From:=1, To:=1, _ Item:=wdExportDocumentWithMarkup, IncludeDocProps:=False, KeepIRM:=True, _ CreateBookmarks:=wdExportCreateNoBookmarks, DocStructureTags:=True, _ BitmapMissingFonts:=True, UseISO19005_1:=False Quote Link to comment Share on other sites More sharing options...
Beyond_Life Posted April 11, 2011 Report Share Posted April 11, 2011 What do you mean with this sentence? Hi,I was thinking of creating a macro that would run the document inspector, automatically remove all on each section (or at least certain sections) Quote Link to comment Share on other sites More sharing options...
Guest rob1 Posted April 11, 2011 Report Share Posted April 11, 2011 there is a document inspector within office 2010 so you can remove all the meta data etc from a document. it catagories the meta types into 5 sections, where you then get a 'remove all' option next to those applicable. what i would like to do is create a macro to inspect/scan a document and then effectively press remove all to each of the sections if they detect any meta data. there is also a 'send as pdf' option within word 2010 so you can email the current document without having to save it to the pc and then create new email and attach it. for business compliance purposes i would like to be able to clear a document of meta data and then simply email it with just one click of a button if that makes sense, especially as not all memebers of staff a IT savvy Quote Link to comment Share on other sites More sharing options...
Beyond_Life Posted April 12, 2011 Report Share Posted April 12, 2011 Thats a great sollution, and I hope you get it to work. But sorry, Im no help for you. I have no idea how to build a macro Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.