I have an Excel macro that is used to format an Excel spreadsheet. As part
of the macro an InputBox is used to get the date of the next meeting from the
user (and then this date is used to populate one of the columns in the
spreadsheet. This macro works great when run directly.

I want to run this macro from Access (so that the data can be exported and
formatted automatically). When the InputBox pops up and I start to type in
it, this error pops up:
This action cannot be completed because the application() is not responding.
Choose Switch To to activate and correct the problem.

I can click on "Switch To" and continue, but that is not the result that I
want. Is there any way to avoid this error?

Thank you for your help,
Judy