I want to learn to write macros that can perform tasks that relate to more than 1 Mircosoft software, eg, excel, word.....

could you please suggest books / webs for me?

When I write macro for a task that relate to ONE MS software, i can RECORD the task so as to know which code I should use.
However, for macros for tasks relating to more than 1 software, we can't RECORD.