****************高分关于Excel的问题********* 如何用VB操作Excel的表头,表尾。如何将一个Excel中的一页表格行全部加上表格线(预览时显示表格线) 最好有例子:) 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 With xlSheet .Range(.Cells(1, 1), .Cells(1, 9)).Font.Name = "黑体" '设标题为黑体字 .Range(.Cells(1, 1), .Cells(1, 9)).Font.Bold = True '标题字体加粗 .Range(.Cells(1, 1), .Cells(1, 9)).Borders.LineStyle = xlContinuous '设表格边框样式 End With With app.ActiveSheet.PageSetup .LeftHeader = "" .CenterHeader = "" .RightHeader = "" .LeftFooter = "" .CenterFooter = "" .RightFooter = "" .LeftMargin = app.Application.InchesToPoints(0.354330708661417) .RightMargin = app.Application.InchesToPoints(0.354330708661417) .TopMargin = app.Application.InchesToPoints(0.196850393700787) .BottomMargin = app.Application.InchesToPoints(0.196850393700787) .HeaderMargin = app.Application.InchesToPoints(0.118110236220472) .FooterMargin = app.Application.InchesToPoints(0.118110236220472) .PrintHeadings = False .PrintGridlines = False .PrintComments = xlPrintNoComments .PrintQuality = 600 .CenterHorizontally = True .CenterVertically = True .Orientation = xlPortrait .Draft = False .PaperSize = xlPaperA4 .FirstPageNumber = xlAutomatic .order = xlDownThenOver .BlackAndWhite = False .Zoom = 100End With告訴你一招﹐在excel里錄制宏----把你想要得到的效果在excel里操作一遍﹐錄下操作的宏﹐在編輯中看看這些宏﹐你就知道該這么做了 (copy ---->paste) 读卡器的问题 如何判多维断数组的维数. textout输出的位置问题 激活窗体 共享我原创的平面按钮控件!!! 关于 PrintForm 的使用 在VB,怎么样将一个图片填充picture框? (100分)关于toolbar里的菜单按钮..能否加图片呢 请帮忙看看以下代码出现什么问题 VB高手请注意: 一个关于报表的问题,在家进来看看 我用FindFirstFile和FindNextFile遍历目录下指定扩展名怎吗不行?
.Range(.Cells(1, 1), .Cells(1, 9)).Font.Name = "黑体"
'设标题为黑体字
.Range(.Cells(1, 1), .Cells(1, 9)).Font.Bold = True
'标题字体加粗
.Range(.Cells(1, 1), .Cells(1, 9)).Borders.LineStyle = xlContinuous
'设表格边框样式
End With
.LeftHeader = ""
.CenterHeader = ""
.RightHeader = ""
.LeftFooter = ""
.CenterFooter = ""
.RightFooter = ""
.LeftMargin = app.Application.InchesToPoints(0.354330708661417)
.RightMargin = app.Application.InchesToPoints(0.354330708661417)
.TopMargin = app.Application.InchesToPoints(0.196850393700787)
.BottomMargin = app.Application.InchesToPoints(0.196850393700787)
.HeaderMargin = app.Application.InchesToPoints(0.118110236220472)
.FooterMargin = app.Application.InchesToPoints(0.118110236220472)
.PrintHeadings = False
.PrintGridlines = False
.PrintComments = xlPrintNoComments
.PrintQuality = 600
.CenterHorizontally = True
.CenterVertically = True
.Orientation = xlPortrait
.Draft = False
.PaperSize = xlPaperA4
.FirstPageNumber = xlAutomatic
.order = xlDownThenOver
.BlackAndWhite = False
.Zoom = 100
End With
告訴你一招﹐在excel里錄制宏----把你想要得到的效果在excel里操作一遍﹐錄下操作的宏﹐在編輯中看看這些宏﹐你就知道該這么做了 (copy ---->paste)