主题：请指教

是否存在这个文件？msgbox（(ProjectPath & "Attachments\晨午检上报表.xlsx")）

真是无奈啊，就这么个代码为什么就不行呢？文件也有，没什么错呀。退出是还显示什么堆栈不能。。。

 

Dim Book As New XLS.Book(ProjectPath & "Attachments\晨午检上报表.xlsx")
Dim fl As String = ProjectPath & "晨午检报表\" & "晨午检上报表" & Tables("晨午检").current("报告日期") & ".xlsx"

Dim s As String
For Each r As Row In Tables("晨午检").GetCheckedRows
    s =s & "," & r("_Identify")
Next
s = s.Trim(",")
Tables("晨午检").Filter = "[_Identify] in (" & s & ")"
Book.Build() '生成细节区

Dim Proc As New Process '打开工作簿
Proc.File = fl
'Proc.Verb = "Print" '指定动作
Proc.Start()

请上传实例说明

后缀改为.xls后又显示：

.NET Framework 版本：4.0.30319.1026
Foxtable 版本：2020.5.29.8
错误所在事件：Build
详细错误信息：
打开存储文件失败。

 

 

 

Dim Book As New XLS.Book(ProjectPath & "Attachments\晨午检上报表.xlsx")  
Dim fl As String = ProjectPath & "晨午检报表\" & "晨午检上报表" & Tables("晨午检").current("报告日期") & ".xlsx"    

Dim s As String
For Each r As Row In Tables("晨午检").GetCheckedRows
    s =s & "," & r("_Identify")
Next
s = s.Trim(",")
Tables("晨午检").Filter = "[_Identify] in (" & s & ")"
Book.Build() '生成细节区

Dim Proc As New Process '打开工作簿
Proc.File = fl
'Proc.Verb = "Print" '指定动作
Proc.Start()

打开存储文件失败。就是不存在这个文件！