|
- Sub 导出()
- Dim sh As Worksheet, wb As Workbook, FilePath As String
- Application.ScreenUpdating = False
- Application.DisplayAlerts = False
- FilePath = VBA.Replace(Range("K5").Value, "导出另存为:", "")
- Worksheets("对账单").Copy
- Set wb = ActiveWorkbook
- wb.SaveAs FilePath & "\对账单", 51
- wb.Close True
- Application.DisplayAlerts = True
- Application.ScreenUpdating = True
- End Sub
复制代码
求助-导出当前表另存为指定位置.zip
(167.94 KB, 下载次数: 7)
|
|