|
楼主 |
发表于 2019-8-6 22:00
|
显示全部楼层
您好,老师。
请问我的代码为什么会有问题?可否指教一下?
rightheader:不知道为什么没办法修改字体格式和大小,不知道哪里写的不对。
leftfooter:标注的日期格式无法显示,只能显示成”DD-MM-YY“,不能显示成"DD/MM/YY".
谢谢。
With Sheet1.PageSetup
.LeftHeader = "&G"
.CenterHeader = _
"&""Arial,常规""&10Shangri-La Hotel, Nanchang" & Chr(10) & "" & Chr(10) & "OPMS-GRP Group Rooming List" & Chr(10) & ""
.RightHeader = "&""Arial,常规""&7&"Format(Date, "dd/mm/yy") "& Chr(10) & "&T
.LeftFooter = _
"&""Arial,常规""&7Filter ***From Stay Date " & Format(Sheet2.[b2], "dd/mm/yy") & " ***To Stay Date " & Format(Sheet2.[b3], "dd/mm/yy") & Chr(10) & " Room Class All Room Type All Payment Method All" & Chr(10) & " Block code " & Sheet2.[b1]
.CenterFooter = "&""Arial,常规""&7Page &P of &N" & Chr(10) & "" & Chr(10) & ""
.RightFooter = "&""Arial,常规""&7grprmist" & Chr(10) & "" & Chr(10) & ""
End With
|
|