I am new to VBA/VBScript.
I want to create a task that runs every morning at a certain time. It will open an excel file, and run a macro. The macro would run a RIMES excel add-in query as one of the steps. However, the RIMES excel add-in always prompts for a connection. The username and password is already on the form, all I have to do is click ‘OK’ or ‘Enter’ key (on keyboard), and the macro will continue running to the end. However, this defeats the purpose of the automation.