Cheers for the response guys!
Ive actually fixed the problem now. If I run the "Application.SendKeys {RETURN}" before running Analyst_CubeUpdate the command is saved in cache and used at the next available point.
Application.SendKeys "{RETURN}
Application.SendKeys "{RETURN}...
My problem in brief…
I am running a routine in VBA that requires user intervention, pressing enter three times, before it completes. I want to automate this routine but do not have access to the source code and there are no parameters I can pass to it in order for it to run silently. How do I...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.