I am developing a robot designed to open each file in a folder with an .xlsm file extension, run a refresh macro within each file and then close all on a daily basis. I have tried the ‘type into’, ‘execute macro’ and ‘send hotkey’ methods in an attempt to get the “Connect to DB2 Database” box to open that requires credentials to execute the refresh query, but all three have failed. This is a connection to an IBM DB2 server. Does anybody have guidance on why these different methods cannot trigger this box to open while doing it with a click of the mouse on my own works every time?
Thank you - Kyle