Private Sub CmdChangeFont_Click()On Error GoTo errhandler CommonDialog1.CancelError = True CommonDialog1.Flags = cdlCFEffects Or cdlCFBoth CommonDialog1.ShowFont Me.RichTextBox1.SelFontName = Me.CommonDialog1.FontName Me.RichTextBox1.SelFontSize = Me.CommonDialog1.FontSize Me.RichTextBox1.SelColor = Me.CommonDialog1.Color Me.RichTextBox1.SelBold = Me.CommonDialog1.FontBold Me.RichTextBox1.SelItalic = Me.CommonDialog1.FontItalic Me.RichTextBox1.SelUnderline = Me.CommonDialog1.FontUnderline Me.RichTextBox1.SelStrikeThru = Me.CommonDialog1.FontStrikethru Exit Sub errhandler: Exit Sub End SubPrivate Sub CmdLoadFile_Click() On Error GoTo errhandler
CommonDialog1.Flags = cdlOFNHideReadOnly CommonDialog1.Filter = "Rich Text Files ( *.rtf)|*.rtf" CommonDialog1.FilterIndex = 2 CommonDialog1.ShowOpen Me.RichTextBox1.LoadFile Me.CommonDialog1.FileName Exit Sub
errhandler: Exit Sub End SubPrivate Sub CmdSaveFile_Click() On Error GoTo errhandler CommonDialog1.Filter = "Rich Text Files ( *.rtf)|*.rtf" CommonDialog1.Flags = cdlOFNHideReadOnly CommonDialog1.ShowSave Me.RichTextBox1.SaveFile Me.CommonDialog1.FileName Exit Suberrhandler: Exit Sub End SubPrivate Sub CmdPrint_Click() Dim beginPage, endPage, numCopies, orientation, i CommonDialog1.Flags = cdlOFNHideReadOnly On Error GoTo errhandler CommonDialog1.ShowPrinter beginPage = CommonDialog1.FromPage endPage = CommonDialog1.ToPage numCopies = CommonDialog1.Copies orientation = CommonDialog1.orientation For i = 1 To numCopies Next Exit Suberrhandler: Exit Sub End SubPrivate Sub CmdExit_Click() End End Sub
Dim WordApp As Object Dim TableA Dim I, J As Integer Set WordApp = CreateObject("Word.Application") With WordApp .Documents.Add .Visible = True .Activate .Selection.ParagraphFormat.Alignment = 1 .Selection.TypeText Text:="表1:大家好" Set TableA = .ActiveDocument.Tables.Add(.Selection.Range, 16, 5) TableA.cell(1, 1).Range.insertafter "A1" TableA.cell(1, 2).Range.insertafter "A2" TableA.cell(1, 3).Range.insertafter "A3"
我的邮箱是:
[email protected]
谢谢
Private Sub CmdChangeFont_Click()On Error GoTo errhandler
CommonDialog1.CancelError = True
CommonDialog1.Flags = cdlCFEffects Or cdlCFBoth
CommonDialog1.ShowFont
Me.RichTextBox1.SelFontName = Me.CommonDialog1.FontName
Me.RichTextBox1.SelFontSize = Me.CommonDialog1.FontSize
Me.RichTextBox1.SelColor = Me.CommonDialog1.Color
Me.RichTextBox1.SelBold = Me.CommonDialog1.FontBold
Me.RichTextBox1.SelItalic = Me.CommonDialog1.FontItalic
Me.RichTextBox1.SelUnderline = Me.CommonDialog1.FontUnderline
Me.RichTextBox1.SelStrikeThru = Me.CommonDialog1.FontStrikethru
Exit Sub
errhandler:
Exit Sub
End SubPrivate Sub CmdLoadFile_Click()
On Error GoTo errhandler
CommonDialog1.Flags = cdlOFNHideReadOnly
CommonDialog1.Filter = "Rich Text Files ( *.rtf)|*.rtf"
CommonDialog1.FilterIndex = 2
CommonDialog1.ShowOpen
Me.RichTextBox1.LoadFile Me.CommonDialog1.FileName
Exit Sub
errhandler:
Exit Sub
End SubPrivate Sub CmdSaveFile_Click()
On Error GoTo errhandler
CommonDialog1.Filter = "Rich Text Files ( *.rtf)|*.rtf"
CommonDialog1.Flags = cdlOFNHideReadOnly
CommonDialog1.ShowSave
Me.RichTextBox1.SaveFile Me.CommonDialog1.FileName
Exit Suberrhandler:
Exit Sub
End SubPrivate Sub CmdPrint_Click()
Dim beginPage, endPage, numCopies, orientation, i
CommonDialog1.Flags = cdlOFNHideReadOnly
On Error GoTo errhandler
CommonDialog1.ShowPrinter
beginPage = CommonDialog1.FromPage
endPage = CommonDialog1.ToPage
numCopies = CommonDialog1.Copies
orientation = CommonDialog1.orientation
For i = 1 To numCopies
Next
Exit Suberrhandler:
Exit Sub
End SubPrivate Sub CmdExit_Click()
End
End Sub
Dim TableA
Dim I, J As Integer
Set WordApp = CreateObject("Word.Application")
With WordApp
.Documents.Add
.Visible = True
.Activate
.Selection.ParagraphFormat.Alignment = 1
.Selection.TypeText Text:="表1:大家好"
Set TableA = .ActiveDocument.Tables.Add(.Selection.Range, 16, 5)
TableA.cell(1, 1).Range.insertafter "A1"
TableA.cell(1, 2).Range.insertafter "A2"
TableA.cell(1, 3).Range.insertafter "A3"
可不可以用ole那样的方式,让他从里面显示出来,而且也可以修改添加,但是我不知道,ole如何保存修改。
其他的编辑保存工作由编辑器完成,不过这个方法我没试过,你自己试试,应该可行
Word 提供了一个 Word 对象, 通过在 “引用” 中的该对象, 可以实现对 Word 的控制。以下的代码演示了执行 WordBasic 语句,该段代码是动态引用对象,无须在工程中引用Word 对象。Dim wd As Object
Set wd = CreateObject ("Word.Basic")
wd.FileNewDefault
wd.FontSize 20
wd.Insert "Hello, World"
wd.FileSaveAs "Hello.Doc"
wd.FileClose
Set wd = Nothing执行后,将产生一个 Hello.Doc 。 一个种办法是在 Word 中调试好 WordBasic 语句后, 再发布到 VB 中。类似的处理应该也可以用在 Execl 中。