On my desktop I have one “Word” document and one “Access” document. Each one contains a macro. I want firstly to open my “Word” document and run the macro in it, and then right after that I want the “Access” document to open automatically and run its macro. How can I automate this whole process? Some people told me I need to use Office Automation, but I don’t know how.

Search MSDN and google for "Office Automation". You will probably have to write a VB Script to do that -- note that is not the same thing as a VB program. You could use c++ also, but it will be about 100 times more difficult and complicated.