A webquery will prompt you for username and password when it executes. The webquery object doesn't expose the necessary properties to allow you to programmatically set them. You could either try sending keystrokes to the dialog box, use something more suited to the task than Excel or use a weather source that doesn't require authentication.