[已解决]老师这句代码怎么修改成，将表格保存到YYY文件夹中。

xm2012

    Debug.Print ThisWorkbook.Path & Application.PathSeparator & sWBName & ".xls"
    ActiveWorkbook.SaveAs Filename:=ThisWorkbook.Path & Application.PathSeparator & sWBName, FileFormat:=xlExcel8

最佳答案

月排行榜 / 总排行榜

zjdh

2012-10-27 10:34

Debug.Print ThisWorkbook.Path & "\YYY\" & sWBName & ".xls"
ActiveWorkbook.SaveAs Filename:=ThisWorkbook.Path & "\YYY\" & sWBName, FileFormat:=xlExcel8

跳转到最佳答案楼层

zjdh

Debug.Print ThisWorkbook.Path & "\YYY\" & sWBName & ".xls"
ActiveWorkbook.SaveAs Filename:=ThisWorkbook.Path & "\YYY\" & sWBName, FileFormat:=xlExcel8