Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 03-21-2024, 06:22 AM
fd110 fd110 is offline Send text to footnote without losing comment Windows 10 Send text to footnote without losing comment Office 2021
Novice
Send text to footnote without losing comment
 
Join Date: Nov 2023
Posts: 7
fd110 is on a distinguished road
Default Send text to footnote without losing comment

I got a macro from a friend of the site that sends the text to the footer keeping the formatting
Now my problem is that when I have a comment in that text field, I lose that comment
I wanted, if possible, to send the comment to the number of the footnote in the text before sending the text to the footnote, so that I don't lose the comment.

Code:


Sub Macro1()
Dim oRng As Range, oFN As Footnote, rngInner As Range
Set oRng = ActiveDocument.Range
With oRng.Find
Do While .Execute(FindText:="\[\[(*)\]\]", MatchWildcards:=True)
Set oFN = ActiveDocument.Footnotes.Add(oRng, , oRng.Text)
Set rngInner = oRng.Duplicate
rngInner.MoveStart Unit:=wdCharacter, Count:=2
rngInner.MoveEnd Unit:=wdCharacter, Count:=-2
oFN.Range.FormattedText = rngInner.FormattedText
oRng.Text = ""
Loop
End With
lbl_Exit:
Set oRng = Nothing
Set rngInner = Nothing
Exit Sub
End Sub


Thank you very much, I have another problem.
I have a number of comments in the text, which will be deleted by moving the text to the footnote.
Is there a way to move those comments, for example, to the footnote number in the main text and not delete them?
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Customize footnote reference marks without losing automation RobiNew Word VBA 0 12-20-2023 01:53 AM
Send text to footnote without losing comment Macro to change font size of Footnote Reference in Footnote Text TheBigBoss Word VBA 5 06-10-2022 06:14 AM
Send text to footnote without losing comment Footnote references in the footnote section losing their style when cut+pasted from same doc emblaw Word 4 12-08-2020 06:23 AM
Send text to footnote without losing comment Removing line break and indentation between footnote number and footnote text in Word jaanross Word 5 02-06-2020 12:04 AM
Send text to footnote without losing comment Adding footnote number as part of footnote text NoCalScribe Word VBA 3 07-15-2019 07:20 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:49 PM.


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