Open Filename + SendKeys

[Matthew]

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

 

[Steven Burn]

I didn't think you could go onto the next step if the file wasn't open?

--
Regards

Steven Burn
Ur I.T. Mate Group CEO
www.it-mate.co.uk

 

[jaf]

Hi Matthew,
This works for me.

Workbooks.Open Filename:="http://www.osbornewood.com/_private/test.csv",
password:="yourpasswordhere"

That is the website password, not the file password.

 

[Matthew]

John,

That looks good. However, when I tried it I got the error message:

Compile error:
Syntax error

I looked at it in the debugger, and tried again. The next time it said:

Compile error:
Expected: named parameter

It highlighted the first line. I put the second line (password) on the
first line; it liked that (no error messages) but it still displayed the
dialog box, waiting for me to hit OK.

Matthew

 

[jaf]

Hi Matthew,
It was one line, it wrapped in the newsreader. There should be a comma
before password.

 

[Matthew]

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

Matthew