Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming,microsoft.public.vb.general.discussion
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming,microsoft.public.vb.general.discussion
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming,microsoft.public.vb.general.discussion
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming,microsoft.public.vb.general.discussion
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.programming,microsoft.public.vb.general.discussion
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.programming,microsoft.public.vb.general.discussion
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
GetOpen filename to open files(Workbooks) | Excel Discussion (Misc queries) | |||
Workbooks.Open Filename | Excel Worksheet Functions | |||
set filename to <filename-date on open | Excel Worksheet Functions | |||
Double-CLK open appends a number to filename | Excel Discussion (Misc queries) | |||
why does excel 2002 add a '1' to the filename everytime I open a f | Excel Discussion (Misc queries) |