Hi,
I have a number of data queries being refreshed using A
I have the passwords saved into the connections so that I do not have to enter them while my macro is running. This works for most of the connections however I have a connection to Sage which although it saves the password, still requires me to click ok on a login dialog box. For all other connections this step is bypassed once the username and password are saved in excel.
Is there a way I can OK this dialog box using vba or set it to be bypassed automatically like it does with all other connections? I have tried recording it but the macro recorder records no activity when I click ok.
I have a number of data queries being refreshed using A
HTML:
ctiveWorkbook.RefreshAll
I have the passwords saved into the connections so that I do not have to enter them while my macro is running. This works for most of the connections however I have a connection to Sage which although it saves the password, still requires me to click ok on a login dialog box. For all other connections this step is bypassed once the username and password are saved in excel.
Is there a way I can OK this dialog box using vba or set it to be bypassed automatically like it does with all other connections? I have tried recording it but the macro recorder records no activity when I click ok.