Close One Tab within Chrome via VBA

Question

opening a Google Chrome tab with an already-filled Google Form link URL that syncs to a Google Sheet using Excel VBA.

The opened tab should ideally close after a second.

The different shortkeys I provide this application, however, dismiss every tab. Anyone have a tip for using VBA to close the last Chrome tab that was open?

''' ActiveWorkbook.FollowHyperlink myURL ''' Application.Wait Now + #12:00:01 AM#

Have Tried:

''' Application.SendKeys ("^W") ''' Application.SendKeys ("%{F4}")

Answer 1

Sod's law worked it out within a few mins of posting.

I hope this helps you.