香港新浪網 MySinaBlog
« 上一篇 | 下一篇 »
Emily | 21st Jun 2007, 08:19 AM | API / Add-in | (1271 Reads)

Automatic Mouse Movement

Worth to read this example:  Automatic Mouse Movement on UserForms

I have been using an Excel addin which I had need to automate some procedures overnight. There are a number a userforms which have certain commandbuttons to click. Unfortunately, you cannot access the Command Button click event from external code.
So I searched far and wide for a solution. I found the MouseMove API
routine and adapted it for VBA Userforms.