Open Filename + SendKeys
 

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

Open Filename + SendKeys
 

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
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

Open Filename + SendKeys
 

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.

--

John

johnf202 at hotmail dot com


"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

Open Filename + SendKeys
 

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" wrote in message
...
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.

--

John

johnf202 at hotmail dot com


"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

Open Filename + SendKeys
 

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


--

John

johnf202 at hotmail dot com


"Matthew" wrote in message
...
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" wrote in message
...
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.

--

John

johnf202 at hotmail dot com


"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

Open Filename + SendKeys
 

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