
加好友 发短信
等级:三尾狐
帖子:787
积分:6349
威望:0
精华:0
注册:2008/9/1 8:26:00
|
[求助]EXCEL报表页面设置代码放在哪里? Post By:2008/9/29 13:26:00 [显示全部帖子]
EXCEL报表页面设置代码放在哪里?要指定是哪一张报表吗?岂不是每张报表都横向输出?
Dim Book As New XLS.Book Dim Sheet As XLS.Sheet = Book.Sheets(0) With Sheet.PrintSetting .PaperKind = 9 '设为A4纸 .LandScape = True '横向打印 .MarginLeft = 10'左右边距设为20毫米 .MarginRight = 10 .MarginTop = 15 '上下边距设为15毫米 .MarginBottom = 15 End With
|
|