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

See VBA help

Built-In Dialog Box Argument Lists


"David" wrote:

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