Where is document inspector in excel code#
I found the code below to be placed in the workbook module. Therefore, I used my usual approach and searched the internet to find a solution. The only annoying thing was the fact that I was getting the 'Document Inspector' warning message. I don't know if this is the most efficient way, but it works. IncOrDec = InputBox("Enter the percentage of Increase or Decrease without the % sign")ĮndPrice = Evaluate(StartPrice.Address & "* (1+" & IncOrDec & "/100)") Set EndPrice = EndFile.Worksheets("DRF").Range("D10:D29") Set StartPrice = StartFile.Worksheets("DRF").Range("D10:D29") Set EndFile = Workbooks.Open(FolderPath & "\" & FileCopyName & ".XLSM") Set StartFile = Workbooks.Open(FolderPath & "\" & FileName) We can also put more directions here.")ĪctiveWorkbook.SaveCopyAs (FolderPath & "\" & FileCopyName & ".XLSM") New file will be saved in the same folder. So finally we have a Report Inspector that will help you when you are developing reports or report extensions to see what was actually sent to the dataset of the report.FolderPath = įileName = įileCopyName = InputBox("Please enter new file name after incrase.
To use the Document Inspector: Open an Office document to inspect for hidden data or personal information.
Where is document inspector in excel update#
Yes! It’s here! The long awaited Report Inspector in Business Central.ĭon’t know what I’m talking about, well let me bring you up-to-date:Īnd now, with the release of Update 18.3 for Microsoft Dynamics 365 Business Central online 2021 release wave 1, we have these 2 amazing features: Word, Excel, and PowerPoint 20 use the Document Inspector tool to search for and remove both personal data and tracked changes to a document.