Trevor3007
Well-known Member
- Joined
- Jan 26, 2017
- Messages
- 675
- Office Version
- 365
- Platform
- Windows
hi ,
i currently use the following code:-
all is good until I run it with new file name , how can i solve this please?
KR
Trevor3007
i currently use the following code:-
Code:
Sub PrntEU()'
' PrntEU Macro
' print as PDF TimeSheet & EXP
'
'
Range("A1:J22").Select
ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:= _
"C:\UsersTimesheets\To Be Approved\TSheet WC 11-02-2019.pdf" _
, Quality:=xlQualityStandard, IncludeDocProperties:=True, IgnorePrintAreas _
:=False, OpenAfterPublish:=False
Sheets("Expenses-Reimburse").Select
ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:= _
"C:\Users\Timesheets\To Be Approved\Exp WC 11-02-2019.pdf" _
, Quality:=xlQualityStandard, IncludeDocProperties:=True, IgnorePrintAreas _
:=False, OpenAfterPublish:=False
Sheets(TSheet WC 11-02-2019").Select
Range("F15").Select
End Sub
all is good until I run it with new file name , how can i solve this please?
KR
Trevor3007