Dim dlg As New SaveFileDialog '定义一个新的SaveFileDialog dlg.Filter= "Excel文件|*.xls" '设置筛选器 dlg.FileName = Format(Date.Now, "yyyyMMdd") & ".xls" If dlg.ShowDialog = DialogResult.Ok Then '如果用户单击了确定按钮 For Each t As Table In Tables t.SaveExcel(dlg.FileName, t.Name) '保存文件 Next End If
|