I am using the following to bring up "Compress Pictures" pop-up box:

    Application.CommandBars.ExecuteMso "PicturesCompress"
How would I select "use document resolution" option and then press "OK"

Tried using:

Application.SendKeys "{DOWN}"
Application.SendKeys "{ENTER}"
but not doing it.
Thanks