Hey guys. Many apologies for the delay on getting back to you. Paul, the script you put together to call all three files worked great! Thank you for making that so simple.

I am trying to add in code to delete the old file prior to downloading the new one, but I am having some issue getting it to run with that script. Here is the code I am trying to add in:

Dim aFile As String
aFile = "ThisWorkbook.Path & "\" & "ProductCatalog.pdf"
If Len(Dir$(aFile)) > 0 Then
Kill aFile
End If

I am trying to figure out to to incorporate it into the attached file. If there is an easier way to do this, I am all ears. Thanks again guys.