主题：excel 标题代码为 <"【"&[!kh]&"】"&[!rq1]&"至"&[!rq2]&"统计表">

在excel 中可以设置条件吗？如符合某条件 标题为XXX  符合另外条件 标题为YYY

<加工单,-28>

改成

<加工单综合查询_Table1,-28>

多谢

多谢 搞定了 ，还有excel中标题代码其实可以放在打印代码中 换成 这样

vars("khmc")=e.Form.Controls("khname").text
vars("rqa")=e.Form.Controls("startdate").text
vars("rqb")=e.Form.Controls("enddate").text
Dim Book As New XLS.Book(ProjectPath & "Attachments\查询.xls")
Dim fl As String = ProjectPath & "Reports\查询.xls"

''
Dim Sheet As XLS.Sheet = Book.Sheets(0)
Sheet(0,1).Value ="单位:XXX"
''
Book.Build()
Book.Save(fl)
Dim App As New MSExcel.Application
App.Visible = False
App.Caption = "汉思软件"
Dim Wb As MSExcel.WorkBook = App.WorkBooks.Open(fl)
Dim Ws As MSExcel.WorkSheet = Wb.WorkSheets(1)
App.Visible = True
Ws.PrintPreview
App.Quit