VBA 如何打开Word时弹出对话框? 如何在页眉中的表格中插入值?

'当打开Word时弹出对话框 要用户输入内容
Private Sub Document_Open()
'    MsgBox "asaaaaaaaaaaaa"
    AddHeader.Show
End Sub

点击按钮后弹出页面
Private Sub CommandButton3_Click()
    AddHeader.Show
End Sub

'''''''''''''''''''''--------------------------------------------------
Private Sub CmdClear_Click()
TxtFileName.Value = ""
TxtID.Value = ""
TxtSecrecy.Value = ""
TxtRev.Value = ""

End Sub

//在页眉中的表格中插入值.
Private Sub CommandButton1_Click()

With ActiveDocument.Sections(1)
'Cell(4, 2).Range.InsertBefore (TextBox4.value)

    ' .Headers(wdHeaderFooterPrimary).Range.Tables(1).Cell(1, 2).Range.InsertAfter ("aaa")
  .Headers(wdHeaderFooterPrimary).Range.Tables(1).Cell(1, 3).Range.Delete
  .Headers(wdHeaderFooterPrimary).Range.Tables(1).Cell(1, 3).Range.InsertAfter (TxtFileName.Value)
 
  .Headers(wdHeaderFooterPrimary).Range.Tables(1).Cell(2, 2).Range.Delete
  .Headers(wdHeaderFooterPrimary).Range.Tables(1).Cell(2, 2).Range.InsertAfter (TxtSecrecy.Value)
  
  .Headers(wdHeaderFooterPrimary).Range.Tables(1).Cell(2, 4).Range.Delete
  .Headers(wdHeaderFooterPrimary).Range.Tables(1).Cell(2, 4).Range.InsertAfter (TxtRev.Value)
 
  .Headers(wdHeaderFooterPrimary).Range.Tables(1).Cell(2, 6).Range.Delete
  .Headers(wdHeaderFooterPrimary).Range.Tables(1).Cell(2, 6).Range.InsertAfter (TxtID.Value)
 
    '页尾的做法
'    .Footers(wdHeaderFooterPrimary).Range.Text = "Copyright  BYD Company Limited"
End With
AddHeader.Hide
End Sub

Private Sub CommandButton2_Click()
AddHeader.Hide
End Sub

posted @ 2007-08-16 16:50  wj-conquer  阅读(1474)  评论(0编辑  收藏  举报