Does anyone know of a site that shows how to control another application through excel. I know how to use sendkeys, but Id like to know more about putting controls in the macro. Like stopping the user from trying to use another application while the macro is still running or a copy of a macro using sendkeys to another program.

Anyone who read the subject header and is interested in controlling another application through excel, go to help in the visual basic screen and search "SENDKEYS METHOD".

All help appreciated