|
大神帮忙改一下下面代码,目前存储路径乱跳,有时候在文档文件夹有时候在桌面,有时候在其他文件夹,怎么设置成固定文件夹
Sub test()
Application.DisplayAlerts = False
print_1 = ActiveSheet.PageSetup.PrintArea
r1 = Range(ActiveSheet.PageSetup.PrintArea).Rows.Count / ActiveSheet.PageSetup.Pages.Count
r = ActiveSheet.Range("a" & Rows.Count).End(xlUp).Row
C = Application.WorksheetFunction.RoundUp(r / r1, 0)
ActiveSheet.PageSetup.PrintArea = "$A$1" & ":" & "$M$" & C * 50
ActiveSheet.PrintOut PrintToFile:=True, PrToFileName:=Sheets("采购单").Range("J2").Value & Sheets("采购单").Range("b2").Value & "采购订单.PDF"
ActiveSheet.PageSetup.PrintArea = print_1
Application.DisplayAlerts = False
ActiveWorkbook.SaveAs Filename:=Sheets("采购单").Range("J2").Value & Sheets("采购单").Range("b2").Value & "采购订单.xlsm", _
FileFormat:=xlOpenXMLWorkbookMacroEnabled, CreateBackup:=False
End Sub
增加一句:
PT="D:\" '即路径
将
ActiveSheet.PrintOut PrintToFile:=True, PrToFileName:=Sheets("采购单").Range("J2").Value.......
改为
ActiveSheet.PrintOut PrintToFile:=True, PrToFileName:=PT & Sheets("采购单").Range("J2").Value.......
将
ActiveWorkbook.SaveAs Filename:=Sheets("采购单").Range("J2").Value .....
改为
ActiveWorkbook.SaveAs Filename:=PT & Sheets("采购单").Range("J2").Value
|
|