![]() |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
![]()
Would love any help on how to copy/paste articles like the ones in the links below into Word and then run a macro that only preserves the text of the news article and changes it to a standard format (such as Arial font in size 11 in the color black - with paragraphs and spacing all consistent). The articles online are full of pictures, ads, columns, links, etc. and I just need to preserve the actual content of the article for 100+ pages every day. Also including what I've written so far for the macro below the article links. Would appreciate any help - thank you so much.
Analysis: Silicon Valley'''s greatest minds misread pandemic demand. Now their employees are paying for it. | CNN Business UN Expert Group Proposes Rules for Net Zero Commitments - ESG Today https://apnews.com/article/challenge...94f142fea26126 5 facts drivers need to know about tech-enabled safety features Sub Macro1() ' ' Macro1 Macro ' ' Selection.WholeStory With Selection.Font .Name = "Arial" .Size = 11 .Italic = False .Underline = wdUnderlineNone .UnderlineColor = wdColorAutomatic .StrikeThrough = False .DoubleStrikeThrough = False .Outline = False .Emboss = False .Shadow = False .Hidden = False .SmallCaps = False .AllCaps = False .Engrave = False .Superscript = False .Subscript = False .Spacing = 0 .Scaling = 100 .Position = 0 .Animation = wdAnimationNone .Ligatures = wdLigaturesNone .NumberSpacing = wdNumberSpacingDefault .NumberForm = wdNumberFormDefault .StylisticSet = wdStylisticSetDefault .ContextualAlternates = 0 End With With Selection.ParagraphFormat .LeftIndent = InchesToPoints(0) .RightIndent = InchesToPoints(0) .SpaceBefore = 0 .SpaceBeforeAuto = False .SpaceAfter = 12 .SpaceAfterAuto = False .LineSpacingRule = wdLineSpaceSingle .Alignment = wdAlignParagraphLeft .WidowControl = True .KeepWithNext = False .KeepTogether = False .PageBreakBefore = False .NoLineNumber = False .Hyphenation = True .FirstLineIndent = InchesToPoints(0) .CharacterUnitLeftIndent = 0 .CharacterUnitRightIndent = 0 .CharacterUnitFirstLineIndent = 0 .LineUnitBefore = 0 .LineUnitAfter = 0 .MirrorIndents = False .TextboxTightWrap = wdTightNone .CollapsedByDefault = False End With Selection.Find.ClearFormatting Selection.Find.Replacement.ClearFormatting With Selection.Find .Text = "( ){2,}" .Replacement.Text = " " .Forward = True .Wrap = wdFindAsk .Format = False .MatchCase = False .MatchWholeWord = False .MatchAllWordForms = False .MatchSoundsLike = False .MatchWildcards = True End With Selection.Find.Execute Replace:=wdReplaceAll Selection.Find.ClearFormatting Selection.Find.Replacement.ClearFormatting With Selection.Find .Text = "^m" .Replacement.Text = "" .Forward = True .Wrap = wdFindAsk .Format = False .MatchCase = False .MatchWholeWord = False .MatchAllWordForms = False .MatchSoundsLike = False .MatchWildcards = True End With Selection.Find.Execute Replace:=wdReplaceAll Selection.Find.ClearFormatting Selection.Find.Replacement.ClearFormatting With Selection.Find .Text = "^p^p" .Replacement.Text = "^p" .Forward = True .Wrap = wdFindAsk .Format = False .MatchCase = False .MatchWholeWord = False .MatchWildcards = False .MatchSoundsLike = False .MatchAllWordForms = False End With Selection.Find.Execute Replace:=wdReplaceAll Selection.Find.ClearFormatting Selection.Find.Replacement.ClearFormatting With Selection.Find .Text = "^g" .Replacement.Text = "" .Forward = True .Wrap = wdFindAsk .Format = False .MatchCase = False .MatchWholeWord = False .MatchWildcards = False .MatchSoundsLike = False .MatchAllWordForms = False End With Selection.Find.Execute Replace:=wdReplaceAll End Sub |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Default size of pasted pictures | Corner_Boy | Word | 4 | 08-21-2021 06:01 AM |
Problem copy/pasting internet articles to Word 2016 | cricket1001 | Word | 1 | 03-16-2021 06:16 PM |
Create News Summary log into Excel with the latest news starting in cell A2 | Matrix2021 | Excel | 0 | 12-26-2020 06:37 AM |
![]() |
WaltR | Word | 9 | 09-20-2013 05:58 PM |
Package for CD with links to Windows media player content and Flash Shockwave content | hectorh | PowerPoint | 4 | 10-15-2009 12:22 PM |