Dialog Arguements

[David]

Hello

I need to execute a web query but the user must input username & password
and enter some information in the next window after logging in to get the
information. I need to continue to run the code but it wont wait for the
query to refresh before running the next line of code.

I thought maybe I could solve this by changing the RefreshBackground
property but I can't figure out how to set that property if I am using the
dialog.

this is the line of code I run to execute the dialog:
Application.Dialogs(xlDialogNewWebQuery).Show (strUrl)

Can I change the RefreshBackground property to false in this line?
Or are there any other ways of doing this?

David

 

[Joel]

See VBA help

Built-In Dialog Box Argument Lists

 

[David]

I have seen that help page.
It does not list any arguements for xlDialogNewWebQuery