Skip to Content
Aug 28, 2018 at 08:07 AM

EPM VBA end sub if logon window is closed without logging on

225 Views Last edit Aug 28, 2018 at 11:54 AM 2 rev

I am just starting to automate some of my EPM reports (I am also brand new to EPM, just started using a few weeks ago), and I am using EPM.Logon to log on. How ever I want to be able to end the macro if someone closes the logon window without logging on.

Currently when I close the window, I get a VBA run time error saying "Error in ClearAllCachestoGet - Excel"

Any help is appreciated.