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.
Vladimirr 0 Newbie Poster
Ancient Dragon 5,243 Achieved Level 70 Team Colleague Featured Poster
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.
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.