Hi there,
This is my first post so apologies for any double-ups.
The current Macro I am using to save a sheet in PDF to a certain location seems to change the location based on my last saved location, even though it has a location where I would like to save it to indicated. Can anyone please assist if I am missing something?
Sheets("00373 Ballarat Dealer").Select
Range("A1:P181").Select
ChDir "I:\PARTS Master\6. Parts Support\Parts Reports\Dealer Business Plans\DEALER BUSINESS PLANS PDF - Do not remove"
'
Selection.ExportAsFixedFormat Type:=xlTypePDF, Filename:= _
sFileName & Range("E7").Value & " - " & sFileName & Range("E9").Value & ".pdf", Quality:= _
xlQualityStandard, IncludeDocProperties:=True, IgnorePrintAreas:=False, _
OpenAfterPublish:=False
This is my first post so apologies for any double-ups.
The current Macro I am using to save a sheet in PDF to a certain location seems to change the location based on my last saved location, even though it has a location where I would like to save it to indicated. Can anyone please assist if I am missing something?
Sheets("00373 Ballarat Dealer").Select
Range("A1:P181").Select
ChDir "I:\PARTS Master\6. Parts Support\Parts Reports\Dealer Business Plans\DEALER BUSINESS PLANS PDF - Do not remove"
'
Selection.ExportAsFixedFormat Type:=xlTypePDF, Filename:= _
sFileName & Range("E7").Value & " - " & sFileName & Range("E9").Value & ".pdf", Quality:= _
xlQualityStandard, IncludeDocProperties:=True, IgnorePrintAreas:=False, _
OpenAfterPublish:=False