i'm not sure how to do it through VBA, but you can accomplish all of the goals in this thread with autoit very quickly and easily. check it out at autoitscript.com/autoiot3 there's another very helpful forum over there, and if you have any questions about the language feel free to message me here or there (my name there is cameronsdad)
Can you give a sample code for using autoit in vba?
