Can I use SendKeys (or another method) to automate the entry of a password, tab once, and "enter"? I purposefully optioned to not retain the password with the workbook when originally creating the connection. <Insert VBA security jokes here>.

This code refreshes the listobject, which then prompts for the entry indicated above. The cursor is active to the box I enter the password in. Can I not pass a string to that box?

Please Login or Register  to view this content.