Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-07-2023, 08:45 AM
bblelli bblelli is offline Keeping only the "vertical revision marks" when exporting to ".pdf" Windows 10 Keeping only the "vertical revision marks" when exporting to ".pdf" Office 2021
Novice
Keeping only the "vertical revision marks" when exporting to ".pdf"
 
Join Date: Feb 2023
Posts: 22
bblelli is on a distinguished road
Angry Keeping only the "vertical revision marks" when exporting to ".pdf"

Hello guys,

I'm doing my best but I really don't know how to export my WORD document to PDF and highlight the revisions I made on my document.

Some manuals around the world usually displays a vertical revision line at the left side of the affected text (the text there were added or replaced) in order to show that this line of your new manual's version were eddited.

And this is what I'm trying to do, but the problem is that if I enable the tracking changes and export to PDF, the new document is not an official manual, but just a document showing that we are still working on it.

Please, check the pictures for a better clarification.

How can I create a VBA code that exports my document to .pdf (with everything perfectly displayed as the final and approved version) but with vertical lines showing where the text were eddited?

I don't care if it's revison mark, a line, or even an external border (etc...) I just need this kind of highlight.



Thanks a lot!
Attached Images
File Type: jpg Picture.jpg (140.1 KB, 7 views)
Reply With Quote
  #2  
Old 05-07-2023, 04:49 PM
Guessed's Avatar
Guessed Guessed is offline Keeping only the "vertical revision marks" when exporting to ".pdf" Windows 10 Keeping only the "vertical revision marks" when exporting to ".pdf" Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 3,975
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

I recorded a few settings and this appears to give a result that only shows the sidebars
Code:
Sub ExportPdfSidebars()
  With Options
    .InsertedTextMark = wdInsertedTextMarkNone
    .InsertedTextColor = wdBlue
    .DeletedTextMark = wdDeletedTextMarkHidden
    .DeletedTextColor = wdPink
    .RevisedPropertiesMark = wdRevisedPropertiesMarkNone
    .RevisedPropertiesColor = wdByAuthor
    .RevisedLinesMark = wdRevisedLinesMarkOutsideBorder
    .CommentsColor = wdByAuthor
    .RevisionsBalloonPrintOrientation = wdBalloonPrintOrientationPreserve
    .MoveFromTextMark = wdMoveFromTextMarkDoubleStrikeThrough
    .MoveFromTextColor = wdGreen
    .MoveToTextMark = wdMoveToTextMarkDoubleUnderline
    .MoveToTextColor = wdGreen
    .InsertedCellColor = wdCellColorLightBlue
    .MergedCellColor = wdCellColorLightYellow
    .DeletedCellColor = wdCellColorPink
    .SplitCellColor = wdCellColorLightOrange
  End With

  ActiveWindow.View.RevisionsMode = wdInLineRevisions

  ActiveDocument.ExportAsFixedFormat OutputFileName:="C:\TestFolder\SavedVersion.pdf", _
    ExportFormat:=wdExportFormatPDF, OpenAfterExport:=True, OptimizeFor:= _
    wdExportOptimizeForPrint, Range:=wdExportAllDocument, _
    Item:=wdExportDocumentWithMarkup, IncludeDocProps:=False, KeepIRM:=True, _
    CreateBookmarks:=wdExportCreateNoBookmarks, DocStructureTags:=True, _
    BitmapMissingFonts:=True, UseISO19005_1:=False
  
End Sub
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote
  #3  
Old 05-07-2023, 06:09 PM
bblelli bblelli is offline Keeping only the "vertical revision marks" when exporting to ".pdf" Windows 10 Keeping only the "vertical revision marks" when exporting to ".pdf" Office 2021
Novice
Keeping only the "vertical revision marks" when exporting to ".pdf"
 
Join Date: Feb 2023
Posts: 22
bblelli is on a distinguished road
Default

It's better, but it's still showing the grey shaded area.
Take a look at the picture below!

Thanks
Attached Images
File Type: png New.png (102.7 KB, 6 views)
Reply With Quote
  #4  
Old 05-07-2023, 07:55 PM
Guessed's Avatar
Guessed Guessed is offline Keeping only the "vertical revision marks" when exporting to ".pdf" Windows 10 Keeping only the "vertical revision marks" when exporting to ".pdf" Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 3,975
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

Try adding this line if you have comments in the document as well
Code:
ActiveWindow.View.MarkupMode = wdInLineRevisions
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote
  #5  
Old 05-07-2023, 08:33 PM
bblelli bblelli is offline Keeping only the "vertical revision marks" when exporting to ".pdf" Windows 10 Keeping only the "vertical revision marks" when exporting to ".pdf" Office 2021
Novice
Keeping only the "vertical revision marks" when exporting to ".pdf"
 
Join Date: Feb 2023
Posts: 22
bblelli is on a distinguished road
Angry No, it didn

Thanks, but it didn't work.
I tryied all these alternatives, but it didn't work.

...RevisionsMode...
...MarkupMode...

or inverted

...MarkupMode...
...RevisionsMode...

or just

...RevisionsMode...

or just

...MarkupMode...

None of these options worked.
Reply With Quote
  #6  
Old 05-08-2023, 03:08 PM
bblelli bblelli is offline Keeping only the "vertical revision marks" when exporting to ".pdf" Windows 10 Keeping only the "vertical revision marks" when exporting to ".pdf" Office 2021
Novice
Keeping only the "vertical revision marks" when exporting to ".pdf"
 
Join Date: Feb 2023
Posts: 22
bblelli is on a distinguished road
Angry A different approach - With vertical Lines

Hey guys,

I'm guessing, and I think we can try a different approach.

What if we create a "vertical line" everywhere we have a "vertical revision mark"?

Is it possible to be done?

Thanks
Reply With Quote
  #7  
Old 05-08-2023, 05:04 PM
Guessed's Avatar
Guessed Guessed is offline Keeping only the "vertical revision marks" when exporting to ".pdf" Windows 10 Keeping only the "vertical revision marks" when exporting to ".pdf" Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 3,975
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

Adding a line where this revision mark would sit is not a good idea.

I'm not seeing the balloon area on my output so I think the code is missing one vital ingredient we haven't worked out yet.

Can you post screenshots of your Track Change Options dialog and the Advanced Track Changes Options dialog so we can look at what settings you have?
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote
  #8  
Old 05-08-2023, 05:16 PM
bblelli bblelli is offline Keeping only the "vertical revision marks" when exporting to ".pdf" Windows 10 Keeping only the "vertical revision marks" when exporting to ".pdf" Office 2021
Novice
Keeping only the "vertical revision marks" when exporting to ".pdf"
 
Join Date: Feb 2023
Posts: 22
bblelli is on a distinguished road
Default

Yes, sure...

Please, find the requested info below!
Attached Images
File Type: png Request.PNG (65.8 KB, 5 views)
Reply With Quote
  #9  
Old 05-08-2023, 05:42 PM
Guessed's Avatar
Guessed Guessed is offline Keeping only the "vertical revision marks" when exporting to ".pdf" Windows 10 Keeping only the "vertical revision marks" when exporting to ".pdf" Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 3,975
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

Those settings look similar to mine apart from the Largura preferencial which I have set to zero and doesn't record as a macro step.

Can you set the size of the balloon area to zero as well? To make it editable, you need to go to the Show Markup dropdown > Balloons > and choose to show balloons. Then you can set the preferred width to 0 before going back to turn off the balloons area. Perhaps that will solve your issue.
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote
  #10  
Old 05-08-2023, 06:02 PM
bblelli bblelli is offline Keeping only the "vertical revision marks" when exporting to ".pdf" Windows 10 Keeping only the "vertical revision marks" when exporting to ".pdf" Office 2021
Novice
Keeping only the "vertical revision marks" when exporting to ".pdf"
 
Join Date: Feb 2023
Posts: 22
bblelli is on a distinguished road
Default

The comment tab size reduced, but it's still there.

Should I use your code to export, or it should be done manually (File, Save as...)?
Attached Images
File Type: png Capturar2.PNG (23.0 KB, 5 views)
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Mailto Hyperlink Formula contains too large of "Body" receiving "#Value" need to find workaround MCamera Excel 1 03-02-2022 07:52 PM
Excel 2003: VBA "Function" causes "#VALUE!" errors after running "insert/delete row" custom macro Matt C Excel Programming 2 01-08-2022 06:03 AM
Combine "sort within groups" and "identify duplicate/unique values" in two different variables. civilcervant Excel 3 06-12-2017 07:27 AM
remove repeated words with " macro " or " wild cards " in texts with parentheses and commas jocke321 Word VBA 2 12-10-2014 11:27 AM
Keeping only the "vertical revision marks" when exporting to ".pdf" How to choose a "List" for certain "Heading" from "Modify" tool? Jamal NUMAN Word 2 07-03-2011 03:11 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:02 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft