It is best to avoid overwrite or not dialogs.
e.g.
1. Create a temporary folder.
2. SaveAs to that folder.
3. Copy temp folder files to master folder with no prompts but overwrite if they exist.
(2) is where you do your SendKeys() thing. If your note your keyboard presses, no mouse clicks allowed, then SendKeys() can take those actions. Sounds like you know that part.
If you need help with (1) or (2), please post back.
Once you get it working, we can probably skip the IE object. For that kind of thing, we could probably use the sheetfollowhyperlink event:
Private Sub Workbook_SheetFollowHyperlink(ByVal Sh As Object, ByVal Target As Hyperlink)
Tip: To paste code, do so between code tags. Click the # icon on reply toolbar to insert the code tags easily.