¦p¦ó±Nexcel Range(a1) ¶K¨ì word ¤W
- ©«¤l
- 76
- ¥DÃD
- 33
- ºëµØ
- 0
- ¿n¤À
- 116
- ÂI¦W
- 0
- §@·~¨t²Î
- winxp
- ³nÅ骩¥»
- office2003
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ·s¦Ë
- µù¥U®É¶¡
- 2011-9-29
- ³Ì«áµn¿ý
- 2020-8-25
|
¦p¦ó±Nexcel Range(a1) ¶K¨ì word ¤W
Private Sub CommandButton1_Click()
Dim myTmpFName As String
myTmpFName = ThisWorkbook.Path & Application.PathSeparator _
& "test¤å¥ó.dot"
With New Word.Application
With .Documents.Add(myTmpFName)
.Unprotect
.Tables(2).Cell(1, 1).Range.Text = Worksheets("sheet1").Range(a1)
.Protect wdAllowOnlyFormFields
End With
.Visible = True
End With
End Sub
¥Î .Tables(2).Cell(1, 4).Range.Text = Worksheets("sheet1").Range(a1) ¶K¤£¤W
n«ç»ò¼g ½Ð±Ð¦U¦ì°ª¤â ÁÂÁÂ! |
|
max
|
|
|
|
|
- ©«¤l
- 76
- ¥DÃD
- 33
- ºëµØ
- 0
- ¿n¤À
- 116
- ÂI¦W
- 0
- §@·~¨t²Î
- winxp
- ³nÅ骩¥»
- office2003
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ·s¦Ë
- µù¥U®É¶¡
- 2011-9-29
- ³Ì«áµn¿ý
- 2020-8-25
|
ÁÂÁ±z,¨S°ò¦ªºªì¾ÇªÌ,·PÁÂ! |
|
max
|
|
|
|
|
- ©«¤l
- 472
- ¥DÃD
- 5
- ºëµØ
- 0
- ¿n¤À
- 485
- ÂI¦W
- 0
- §@·~¨t²Î
- Windows
- ³nÅ骩¥»
- MS Office
- ¾\ŪÅv
- 100
- ©Ê§O
- ¨k
- ¨Ó¦Û
- »´ä
- µù¥U®É¶¡
- 2010-7-4
- ³Ì«áµn¿ý
- 2014-12-28
|
¸Õ¸Õ§â
.Tables(2).Cell(1, 1).Range.Text = Worksheets("sheet1").Range(a1)
§ï¦¨
.Tables(2).Cell(1, 1).Range.Text = Worksheets("sheet1").Range("a1") |
|
|
|
|
|
|