
ãå人å°èª¬ãæºæãã¶ã/ã¡ããææã®çžŠæžãæ¿ç¹åã倿ã¯ãŒããã¯ã
ããïœãããã©ããïœãïŒ
æ¿ç¹ãšãã¹ã±ãåããæžããã¯ãããã©ã瞊æžãã®åçš¿çšãã³ãã¬ãŒãã«ã³ããããé端å°ç¡ãã«ãªã£ã¡ãã£ããïœ!!
ããããçµéšãã¿ãªããã«ã¯ãããŸããïŒã誰ãããããšæããŸãã
ãããªã¿ã ããªã®ã³å€ªããã«ãªã¹ã¹ã¡ãªã®ãããã瞊æžãæ¿ç¹åã倿ã¯ãŒããã¯ãïœ!!

ãã®ã¯ãŒããã¯ãã¯ããFïŒãã¿ã³ïŒåæŒããããã¯ãã®å®è¡ãã§ä»¥äžã®çœ®æäœæ¥ãäžæ°ã«è¡ããŸãããŠãã³ãŒãããªãã䜿ããŸãããå¿ããŸããã
ã»åè§ã®ã!!ãã瞊æžãçšã®ã!!ãã«çœ®æ
ã»åè§ã®ã!?ãã瞊æžãçšã®ã!?ãã«çœ®æ
ã»å šè§ã®ããããçµåçšæ¿ç¹ã«çœ®æ
ã»å šè§ã®ãïœïœããçµåãããæ³¢ç·ã«çœ®æ
ã»å šè§ã®ãâãããããŒãããŒã¯ãã«çœ®æ
â»ã¡ãªã¿ã«ããââãïŒããã·ã¥ïŒã¯åéèšå®ãïŒã®æºæææã§ã¯åæã«çµåãããŸãã
â»æåŸã®ãâãã¯äžèŠãªæ¹ã¯æ¶ããŠãã ãããå¥ã®èšå·ãããã£ããããã ãæžãæããŠãã ããã
â»åäœã¯æºæãã¶ãææã»æºæã¡ããææãã©ã³ãã§ç¢ºèª
ïŒãã®ãã©ã³ãã¯ãçµåçšæ¿ç¹ãã€ããã°æ¿ç¹è¡šç€ºããããã«ã§ããããã«ãäœè
ããŸã®åæã«ããæ¿ç¹ä»ãã°ãªãããããŸããïŒ
远èš
倿°žãªãŒã«ãææ3以éã§ã䜿çšå¯èœãšç޹ä»ããã ããŸããâ£
ãã¡ãã®åµäœãTipsããŸã§æäŸããŠããã ããŠããæ¿ç¹ãäžæ¬çœ®æããWordãã¯ããæ°ãªãªãŒã¹ã®å€æ°žãªãŒã«ãææ3以éã§ãäœåããŸããã
â ã€ã@ããããé¡ïŒåçš¿äžïŒ (@ichi_branch) November 5, 2023
æšæºãšã¯ã¹ããŒãã§ã®PDFã®æžãåºãããµãã»ããåãããã«åé¡ãªãããã§ãã
䟿å©ãªãã¯ããããããšãããããŸãðhttps://t.co/p7pLDIJCwZ pic.twitter.com/kI3WFMiJzk
ãããVisualBasicã§ã€ã³ããŒãããã«ãŒãœã«ãåãããFïŒãã¿ã³ãæŒãã°ãåæã«ïŒé£ç¶ã§çœ®æäœæ¥ãèµ°ããŸãããã¯ãã«ã€ããŠã¯ã°ã°ã£ãŠããã
ïŒäžã«å°å
¥æ³ã®è§£èª¬è¿œèšããŸããïŒ
ãã¯ãã®æ³šæç¹ã§ãããäžèšã®ã«ãŒã«ã®éã倿ãããã®ã§ãã?!ãã!!!ãïŒå¥æ°åïŒãªã©ã®äŸå€ã§ã¯ããŸã倿ãããŸããããæ³šæãã
â»ãã¯ãã䜿ã£ãçµæã«ã€ããŠäœã®è²¬ä»»ããããŸãããèªå·±è²¬ä»»ã§ãå¿
ãããã¯ã¢ãããããŠãããã£ãŠãã ããã
[远èš]
ããŸãã«ãã¯ãŒãã®ãã³ãã¬ã¯ãã¡ãã§é
åžäžã
ãæåº«ãµã€ãºãã³ãã¬ã¯ãã¡ãã
ãïŒãµã€ãºãã³ãã¬ã¯ãã¡ãã
ãããµããããïŒãã¯ããé£ãããŠåãããªãããïŒããšããæ¹ã¯ããã¡ããDLããŠçžŠæžãçšã®æåãã³ãããããªãæäœæ¥ã§çœ®æãããªããå¯èœã§ãã
ãã ãã¶åŸã®è¿œèšã2023/10/01
äžã«æžãã[远èšïŒå°å
¥æ³]ããããã£ãšç°¡åãªå°å
¥æ³ããããŸããïŒ
åœãã¯ãã玹ä»ããŠãã ãã£ããã¡ãã®èšäºããšã倢å°èª¬ã»å€¢æŒ«ç»ãå人èªã«ãããïŒâ¡åçš¿ãäœããã®ãããã§ãã
äžã«ãè£èšãããã©ããã¡ãã®èšäºã®ã»ããã¹ã¯ã·ã§ç»åããã£ãŠåãããããã£ãããèŠãŠïŒïŒç޹ä»ã®èš±å¯ããã ããããããšãããããŸããâ¡ïŒ
æäœæ³
衚瀺ã¿ãïŒãã¯ãïŒãã¯ãã®è¡šç€ºïŒã§ãããã¢ãããŠã€ã³ããŠãåºãïŒ
ãã¯ãã®ãç·šéãïŒã§éçºãŠã€ã³ããŠãåºãïŒ
âãã¡ã€ã«ïŒãã¡ã€ã«ã®ã€ã³ããŒããã§ãããã瞊æžãæ¿ç¹åçš¿çšver2.1.basããã€ã³ããŒãããŸã

ã瞊æžãæ¿ç¹åçš¿çšver2.1.basãããã©ãã°ããŠãå¯èœã§ã
ãã®åŸããã¯ãã衚瀺ãã®äžèЧã«ãåçš¿çšäžæ¬çœ®æãã䞊ã³ãŸãã®ã§ããããéžæããŠå®è¡
[远èšïŒå°å
¥æ³]
ãã¯ãããã¿ã³äžçºã§å®è¡ããŠã©ã¯ããã人ãž
ãã®ããŒãžãåèã«ããŠã©ããããã®ãã¯ããäžåã ããµããšäœ¿ãå Žåã以äžã¯äžèŠã§ãã
ã»VBEã®ãªãã·ã§ã³èšå®
ã»ã€ããã£ãšã€ããŠã£ã³ããŠãéã
ã»VBAããã¯ãæå¹ææžãšããŠä¿åãã
äžèšããŒãžã©ããã«ãã£ãŠããæšæºã¢ãžã¥ãŒã«ãã®äžã«ã€ã³ããŒãããããã¯ã³ããã§ãã®ç»åã®ããã«ãªãã°OKã§ããååã¯é©åœã§ããã§ãã

ãã®ç¶æ
ã§ã䜿ããããSubãå
ãã¯ãªãã¯ããŸããç¶ããŠããŒããŒãã®ãF5ããã¿ã³ãæŒããŸãããããšãã¯ãŒãææžã§çœ®æäœæ¥ãèªåçã«è¡ãããŸãã
ã¯ããœæ¥œã§ããåæã«æ¬äžååºãã俺ãèšããã ããééããªãã
ã³ãŒãã¯ä»¥äžã«å
šæè²Œã£ãšããŸããã€ã³ããŒãã§ãªããã¡ããã³ããã§ãOKã
ã¯ãŒãã®éçºã¿ãâVisualBasicâæšæºã¢ãžã¥ãŒã«çã«è²Œãä»ããFïŒã§åããŸãã
Sub åçš¿çšäžæ¬çœ®æ()
'
' åçš¿çšäžæ¬çœ®æãã¯ã
' æ¿ç¹ãïœã!!ã!?ã瞊æžãçšã«æŽåœ¢
' ââããŒãã«çœ®æããã
'å®è¡åã®ããã¯ã¢ãããšãå®è¡åŸã®ç®èŠãã§ãã¯ã¯å¿ããè¡ã£ãŠãã ããã
'åçš¿ãã©ããªã£ãŠãèªå·±è²¬ä»»ã§ãé¡ãããŸãã
'å¶äœè
ãhttps://note.com/kashiri
Selection.Find.ClearFormatting
Selection.Find.Replacement.ClearFormatting
With Selection.Find
.Text = "!!"
.Replacement.Text = ChrW(8252) '瞊æžãçšã®ã!!ã
.Forward = True
.Wrap = wdFindContinue
.MatchWildcards = False
.MatchFuzzy = False
.MatchByte = True
End With
Selection.Find.Execute Replace:=wdReplaceAll
With Selection.Find
.Text = "!?"
.Replacement.Text = ChrW(8265) '瞊æžãçšã®ã!?ã
.Forward = True
.Wrap = wdFindContinue
.MatchWildcards = False
.MatchFuzzy = False
.MatchByte = True
End With
Selection.Find.Execute Replace:=wdReplaceAll
With Selection.Find
.Text = "ã"
.Replacement.Text = ChrW(12441) '瞊æžãçšã®æ¿ç¹
.Forward = True
.Wrap = wdFindContinue
.MatchWildcards = False
.MatchFuzzy = False
.MatchByte = True
End With
Selection.Find.Execute Replace:=wdReplaceAll
With Selection.Find
.Text = "ïœ"
.Replacement.Text = ChrW(12336) '瞊æžãçšã®ãïœïœã
.Forward = True
.Wrap = wdFindContinue
.MatchWildcards = False
.MatchFuzzy = False
.MatchByte = True
End With
Selection.Find.Execute Replace:=wdReplaceAll
'äžèŠãªãæ¶ããŠããâ---------------------------------------
With Selection.Find
.Text = "â" 'ä»»æã®èšå·ã«çœ®ãæããŠãã
.Replacement.Text = ChrW(9825) 'çœãããŒãããŒã¯
.Forward = True
.Wrap = wdFindContinue
.MatchWildcards = False
.MatchFuzzy = False
.MatchByte = True
End With
Selection.Find.Execute Replace:=wdReplaceAll
'äžèŠãªãæ¶ããŠããâ---------------------------------------
End Sub
Sub åçš¿çšäžæ¬çœ®æãæ»ã()
'ãåçš¿çšäžæ¬çœ®æããå
ã«æ»ãã
'ãŠã§ãåé²ãããšããšãã«äœ¿ãã
' 瞊æžãçšã®æ¿ç¹ãïœã!!ã!?ãå
ã«æ»ã
' ããŒãââã«çœ®æããã
'å®è¡åã®ããã¯ã¢ãããšãå®è¡åŸã®ç®èŠãã§ãã¯ã¯å¿ããè¡ã£ãŠãã ããã
'åçš¿ãã©ããªã£ãŠãèªå·±è²¬ä»»ã§ãé¡ãããŸãã
'å¶äœè
ãhttps://note.com/kashiri
'
Selection.Find.ClearFormatting
Selection.Find.Replacement.ClearFormatting
With Selection.Find
.Text = ChrW(8252) '瞊æžãçšã®ã!!ã
.Replacement.Text = "!!"
.Forward = True
.Wrap = wdFindContinue
.MatchWildcards = False
.MatchFuzzy = False
.MatchByte = True
End With
Selection.Find.Execute Replace:=wdReplaceAll
With Selection.Find
.Text = ChrW(8265) '瞊æžãçšã®ã!?ã
.Replacement.Text = "!?"
.Forward = True
.Wrap = wdFindContinue
.MatchWildcards = False
.MatchFuzzy = False
.MatchByte = True
End With
Selection.Find.Execute Replace:=wdReplaceAll
'æ¿ç¹æ»ãã¯ãã®åŸå®è¡ãã
With Selection.Find
.Text = ChrW(12336) '瞊æžãçšã®ãïœïœã
.Replacement.Text = "ïœ"
.Forward = True
.Wrap = wdFindContinue
.MatchWildcards = False
.MatchFuzzy = False
.MatchByte = True
End With
Selection.Find.Execute Replace:=wdReplaceAll
'äžèŠãªãæ¶ããŠããâ---------------------------------------
With Selection.Find
.Text = ChrW(9825) 'çœãããŒãããŒã¯
.Replacement.Text = "â" 'ä»»æã®èšå·ã«çœ®ãæããŠãã
.Forward = True
.Wrap = wdFindContinue
.MatchWildcards = False
.MatchFuzzy = False
.MatchByte = True
End With
Selection.Find.Execute Replace:=wdReplaceAll
'äžèŠãªãæ¶ããŠããâ---------------------------------------
æ¿ç¹æ»ã
End Sub
Sub æ¿ç¹æ»ã()
'瞊æžãçšã«çµåããæ¿ç¹ãå
šè§ã®ãããã«æ»ããŸãã
With Selection.Find
.Text = "([ã-ã])" & ChrW(12441) 'ã²ãããªãã¹ãŠïŒçµåçšæ¿ç¹
.Replacement.Text = "\1ã"
.Wrap = wdFindContinue
.MatchWildcards = True
.MatchFuzzy = False
.MatchByte = True
End With
Selection.Find.Execute Replace:=wdReplaceAll
With Selection.Find
.Text = "([ã¡-ãŽ])" & ChrW(12441) 'ã«ã¿ã«ããã¹ãŠïŒçµåçšæ¿ç¹
.Replacement.Text = "\1ã"
.Wrap = wdFindContinue
.MatchWildcards = True
.MatchFuzzy = False
.MatchByte = True
End With
Selection.Find.Execute Replace:=wdReplaceAll
'ã»ããæŒ¢åãèšå·ã«æ¿ç¹ãã€ãã¡ãã£ãå Žåã¯æ³å®å€ã§ããã
'äžå¿ã以äžã®ã³ã¡ã³ãã¢ãŠãããŠããã€ãã¯äœ¿ãããšæããŸãã
'ã³ã¡ã³ãïŒã'ãïŒãæ¶ããŠå®è¡ããŠã¿ãŠãã ããã
' 'ãã¹ãŠã®æåã«ã€ããŠçœ®æããã
' 'ã¬ãã§ããã¹ãŠããªã®ã§èª€äœåãæããæ®æ®µã¯äžå¿ã³ã¡ã³ãã¢ãŠãããŠãã
' With Selection.Find
' .Text = "(?)" & ChrW(12441) 'ãã¹ãŠã®æåïŒçµåçšæ¿ç¹
' .Replacement.Text = "\1ã"
' .Wrap = wdFindContinue
' .MatchWildcards = True
' .MatchFuzzy = False
' .MatchByte = True
' End With
' Selection.Find.Execute Replace:=wdReplaceAll
End SubãïŒããŸãåçš¿ããªãã£ãŠïŒ
ã¯ããããããèšäºïœïŒå人ãããïŒ
ãããã«è¿œèšã2021/6/14
ã¯ãŒãã®ããŒãžã§ã³ãæ€çŽ¢ã®èšå®ã«ããããã¯ããããŸãåããªãå Žåã«åããããããã£ã远å ããŸãããïŒåè§ãšå
šè§ãåºå¥ããããã«èšå®ïŒ
以åã®ããŒãžã§ã³ã䜿ã£ãŠããæ¹ã¯ãäžæžãããŠãã ããã
ãŸãã以åã¯ã暪æžãâ瞊æžããã®ã¿ã®å€æã ã£ãã®ã§ãããã瞊æžãâæšªæžããã«æ»ãæäœãå¢ãããŸããã
å
šè²¬ä»»ã¯ãšããŸããããåçš¿ããŠã§ãåé²ããæéãççž®ã§ããã¯ãã