If Trim(ls_Path) <> "" Then
ls_Ext = Lower(Right(ls_Path, 3))
Choose Case ls_Ext
Case "xls"
dw_master.SaveAs(ls_Path, Excel!,True)
Case "txt"
dw_master.SaveAs(ls_Path, Text!, True)
Case "htm"
dw_master.SaveAs(ls_Path, HTMLTable!, True)
Case Else
MessageBox("另存为...", "另存格式错误.格式应该" + & "是*.xls'为Excel!;'*.txt'为Text;'*.htm'为HTML Table", Exclamation!, OK!)
Return
End Choose
End if
去试试吧,应该没有问题的。