¿¢¼¿À» ÂüÁ¶ÇÏ¿©
¿öµåÀÇ ¹Ù²Ù±â ¸í·ÉÀ» ¼öÇàÇÏ·Á ÇÕ´Ï´Ù
¿¹¸¦ µé¾î,
A B
1 ¿À¿À ¾Æ¾Æ
2 ¿¡¿¡ ¿ì¿ì
¿Í °°Àº ¿¢¼¿ ÆÄÀÏÀÌ Àִ°æ¿ì
¿öµåÀÇ "¿À¿À"¸¦ ¸ðµÎ "¾Æ¾Æ"·Î ¹Ù²Ù°í "¿¡¿¡"´Â "¿ì¿ì"·Î ¹Ù²Ù´Â ¸ÅÅ©·Î¸¦ ÀÛ¼ºÇÏ·ÁÇÕ´Ï´Ù
ºñº£´Â 1µµ ¸ð¸£Áö¸¸ ÀÏ´Ü ³ª¸§ °Ë»öÇؼ ¼Ò½º¸¦ Â¥ºÃ´Âµ¥ µ¿ÀÛÇÏÁö ¾Ê³×¿ä
Public Sub MakeNotices()
Dim wdApp As Object
Dim wdDoc As Object
Dim wdRng As Object
Dim sh As Worksheet
Set wdApp = CreateObject("Word.Application")
Set sh = Worksheets("Sheet1")
Set wdDoc = wdApp.Documents.Open("C:\Users\Administrator\Documents\ÀÛ¾÷Æú´õ\PD0571\¿À¿À.docx")
Set wdRng = wdDoc.Content
With wdRng.Find
.ClearFormatting
.Replacement.ClearFormatting
.Text = sh.Range("A1")
.Replacement.Text = sh.Range("B1")
.Forward = True
.Wrap = wdFindContinue
.Format = False
.MatchCase = False
.MatchWholeWord = False
.MatchByte = False
.CorrectHangulEndings = True
.HanjaPhoneticHangul = False
.MatchWildcards = False
.MatchSoundsLike = False
.MatchAllWordForms = False
End With
wdDoc.PrintOut
wdApp.DisplayAlerts = False
wdDoc.Close False
wdApp.DisplayAlerts = True
Set wdRng = Nothing
Set wdDoc = Nothing
wdApp.Quit
Set wdApp = Nothing
MsgBox "¿Ï·áµÇ¾ú½À´Ï´Ù."
End Sub
½ÃÇè»ï¾Æ¼ A1ÀÇ ´Ü¾î¸¸ B1À¸·Î ¹Ù²ãº¸´Â ¼Ò½ºÀÔ´Ï´Ù
ÀÌ°Ô µ¿ÀÛÇÑ´Ù¸é A1:Ai À» B1:bi ·Î ¹Ù²Ù´Â ¼Ò½ºµµ °¡´ÉÇÏ°ÚÁÒ..
º°·Î ¾î·Á¿ö º¸ÀÌÁö´Â ¾Ê´Âµ¥ ¾ÈµÇ´Ï ´ä´äÇÏ³×¿ä ¤Ð¤Ð
Á¶¾ðºÎŹµå¸³´Ï´Ù!
|
±¸±Û¿¡¼ ãÀº ¼Ò½ºÀε¥ Çѹø Àû¿ëÇغ¸¼¼¿ä
Àü Å×½ºÆ® Çغôµ¥ Àß µÇ´Â°Å °°³×¿ä
´Ù¸¸ Replace:=1 Çϸé ÇѹøÀÌ°í Replace:=2 Çϸé ÀüüÀεí..