Chosing a file from a popup using VBA

Hey guys,

I am running into a brick wall and could really do with some advice. I have a problem with this website.

https://doubleclick-support.appspot.com/validator/

when you go on this site it asks you to choose a file. From there you select your file and press enter.

Where I’m getting stuck is that I already have the file location in excel and I want VBA to automatically select the file instead of me having to do it manually. Unfortunately, I can’t seem to work out how to handle this so it automatically selects the file.

So far I have created the IE object and got the page to load, from there I trigger the button using ie.document.all.file.Click . But from here onwards I’m stuck, the select file box opens but I have no idea how to handle it.

Any ideas on how this could be done?

Many Thanks,

Michael