If anybody is interested, the answer was to put "SendKeys" before
"Workbooks.Open Filename".

Matthew

"Matthew" wrote in message
...
I am writing a macro for Excel 2002 in VB. I am opening a .csv file from
a
protected part of my web site. I have a dialog box requesting my user
name
and password. Excel remembered the values from last time, so all I have
to
do is click "OK" or hit enter on the keyboard.

I tried the following script, but it seems to want to finish Open Filename
before going on to SendKeys.

Workbooks.Open Filename:= _
"http://www.osbornewood.com/_private/test.csv"
SendKeys "{ENTER}"

How can I make it go on to the next step without waiting for the document
to
actually open? (The SendKeys "{ENTER}" is to get past the dialog box.)

Is this the right general idea, or am I totally on the wrong track?

Matthew