I have a project in which I need to go back and forth between access and excel over and over (200+ times each time I run the project). Within each application, I run a macro, then go to the other and run a macro, then back to the former… and so on. This is the only way it can be done. How do I build/write a larger macro that can bridge both applications where I can combine both and just press the run button once?
