如何在VB里设置Excel文件的页眉或页脚的字体大小? 各位朋友帮忙,谢谢 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 'Excel中设置页眉字体及大小Private Sub Command2_Click() Dim xlApp As New excel.Application Dim xlBook As excel.Workbook Dim xlSheet As excel.Worksheet xlApp.Caption = "test" Set xlBook = xlApp.Workbooks.Add Set xlSheet = xlBook.Worksheets(1) With xlApp.ActiveSheet.PageSetup .LeftHeader = "&""宋体,斜体""&10中国" .CenterHeader = "" .RightHeader = "" .LeftFooter = "" .CenterFooter = "" .RightFooter = "" End With xlApp.Visible = TrueEnd Sub .CenterHeader = "&""宋体,加粗""&22中国" 加"&U"即可.CenterFooter = "&U文字" VB6.0MSFlexGrid控件单元格颜色设置 VB调用DLL问题 请教:如何在VB里调用ActiveX DLL DoEvents放开控制权,响应外部消息但是又把自己给挂住了 :( 如何判断是字符还是数值,多种方法求解 关于datareport合计的问题 那为大侠能帮我优化这段代码呀。代码是我写的,我想他的运行速度更快些。 我想确定 Recordset 对象中记录的数目,但该属性返回 –1,怎么解决?(VB6.0+MS-SQL2000) 求助帮忙 关于如何写一个POP的组件的问题 VBA中,连接两个数据库老是有问题, 请高手看一下这个错误:
Private Sub Command2_Click()
Dim xlApp As New excel.Application
Dim xlBook As excel.Workbook
Dim xlSheet As excel.Worksheet
xlApp.Caption = "test"
Set xlBook = xlApp.Workbooks.Add
Set xlSheet = xlBook.Worksheets(1)
With xlApp.ActiveSheet.PageSetup
.LeftHeader = "&""宋体,斜体""&10中国"
.CenterHeader = ""
.RightHeader = ""
.LeftFooter = ""
.CenterFooter = ""
.RightFooter = ""
End With
xlApp.Visible = True
End Sub
.CenterFooter = "&U文字"