This video explains how sendkeys works in VBA with four examples. Both advantages and drawbacks are clearly explained
No download links available.