Hi all,

I'm pretty new to VBA and I have not learned it before but now when starting working one of my jobs is to somehow automate the SAP BI auto-refresh queries. So the problem for me is now that when I schedule the refresh on a particular time the query basically opens, saves the file and closes but I can't get it to press the macro button and actually refresh the file, it does everything but skips the button. Guys, please help me, if you need additional information please do let me know, I will be more than happy if you can help to resolve this.

Button.PNGAssign Macro.PNGmacro.PNG