Looking For any help I am using the below code and works well for want I need however I would like to be able to add the file to my flash drive however when I do the path changes on different computer and the code fails. is there a way I can change the code to work with different drive letters on different computers
Sub SaveCurrentToPDF()
Dim OriginalSheet As String
OriginalSheet = ActiveSheet.Name
ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:= _
"f:\PDF\" & "book 1" & Format(Range("z4").Value, "dd-mmm-yy") & ".pdf"
'Reset location
Sheets(OriginalSheet).Select
End Sub
Thanks
Bookmarks