I have written a cookbook post over here
What you will need is #6.
But if its too much code for you then you can write a simple vbscript (or call a VBA macro) to achieve the same and will also get tons of available code on the internet.
Another option is the sendkeys to access the menu of the Excel ribbon, but I will recommend that as the last option.
