Hi,
Want to know if it is possible to code a macro to automate the password input that is required every time I refresh data?

The pseudo code looks something like the following:

select a cell
refresh all data
**HOST, USERNAME, AND PASS INPUT BOX NOW APPEARS**

The aim is to replace that last line with something like

user = 'userN@me' password = 'pá$$word'

(but obviously in the correct VBA syntax)

Thanks in advance for any help,

Dan