ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   IE automation (https://www.excelbanter.com/excel-programming/443403-ie-automation.html)

fi.or.jp.de

IE automation
 
Hi All,

I have small automation from excel to web.

I have no problem in logging into the web & input some values in text
box.

But there is browse option, i need input the path in the text box.
I am not able to input.

''''''''''HTML Source CODE''''''''''''''''''

<labelSpreadsheet:</label
<input type="file" name="upload" size="25" value=""
id="spreadsheet_upload"/

''''''''''HTML Source CODE''''''''''''''''''

So, I was using

set Spreads = ie.document.getelementsbyname("upload")
SpreadS.item(0).value = "D:\new folder\abc.xls"

ron

IE automation
 
On Jul 25, 5:59*am, "fi.or.jp.de" wrote:
Hi All,

I have small automation from excel to web.

I have no problem in logging into the web & input some values in text
box.

But there is browse option, i need input the path in the text box.
I am not able to input.

''''''''''HTML Source CODE''''''''''''''''''

<labelSpreadsheet:</label
* * <input type="file" name="upload" size="25" value=""
id="spreadsheet_upload"/

''''''''''HTML Source CODE''''''''''''''''''

So, I was using

set Spreads = ie.document.getelementsbyname("upload")
SpreadS.item(0).value = "D:\new folder\abc.xls"


It would help if you could post the url of the website in
question...Ron

fi.or.jp.de

IE automation
 
https://grid.rdc.com/wss/security/login.html

I don't have problem in login , After my login, There is one browse
button.

I want to input full file path and click submit.

I couldn't able to input the file path.



On Jul 25, 6:02*pm, ron wrote:
On Jul 25, 5:59*am, "fi.or.jp.de" wrote:



Hi All,


I have small automation from excel to web.


I have no problem in logging into the web & input some values in text
box.


But there is browse option, i need input the path in the text box.
I am not able to input.


''''''''''HTML Source CODE''''''''''''''''''


<labelSpreadsheet:</label
* * <input type="file" name="upload" size="25" value=""
id="spreadsheet_upload"/


''''''''''HTML Source CODE''''''''''''''''''


So, I was using


set Spreads = ie.document.getelementsbyname("upload")
SpreadS.item(0).value = "D:\new folder\abc.xls"


It would help if you could post the url of the website in
question...Ron



Harald Staff[_2_]

IE automation
 
Ok so the mystery is on a password protected page. How can we assist?

Best wishes Harald


"fi.or.jp.de" wrote in message
...
https://grid.rdc.com/wss/security/login.html

I don't have problem in login , After my login, There is one browse
button.

I want to input full file path and click submit.

I couldn't able to input the file path.



On Jul 25, 6:02 pm, ron wrote:
On Jul 25, 5:59 am, "fi.or.jp.de" wrote:



Hi All,


I have small automation from excel to web.


I have no problem in logging into the web & input some values in text
box.


But there is browse option, i need input the path in the text box.
I am not able to input.


''''''''''HTML Source CODE''''''''''''''''''


<labelSpreadsheet:</label
<input type="file" name="upload" size="25" value=""
id="spreadsheet_upload"/


''''''''''HTML Source CODE''''''''''''''''''


So, I was using


set Spreads = ie.document.getelementsbyname("upload")
SpreadS.item(0).value = "D:\new folder\abc.xls"


It would help if you could post the url of the website in
question...Ron



muddan madhu

IE automation
 
Ok.... I got similar site to test my requirement.

If you navigate to this web http://www.2shared.com/

How to input the file path in the specified text box or how to click
browse button without manually.


On Jul 25, 9:29*pm, "Harald Staff" wrote:
Ok so the mystery is on a password protected page. How can we assist?

Best wishes Harald

"fi.or.jp.de" wrote in message

...https://grid.rdc.com/wss/security/login.html

I don't have problem in login , After my login, There is one browse
button.

I want to input full file path and click submit.

I couldn't able to input the file path.

On Jul 25, 6:02 pm, ron wrote:

On Jul 25, 5:59 am, "fi.or.jp.de" wrote:


Hi All,


I have small automation from excel to web.


I have no problem in logging into the web & input some values in text
box.


But there is browse option, i need input the path in the text box.
I am not able to input.


''''''''''HTML Source CODE''''''''''''''''''


<labelSpreadsheet:</label
<input type="file" name="upload" size="25" value=""
id="spreadsheet_upload"/


''''''''''HTML Source CODE''''''''''''''''''


So, I was using


set Spreads = ie.document.getelementsbyname("upload")
SpreadS.item(0).value = "D:\new folder\abc.xls"


It would help if you could post the url of the website in
question...Ron



ron

IE automation
 
On Jul 25, 1:18*pm, muddan madhu wrote:
Ok.... I got similar site to test my requirement.

If you navigate to this webhttp://www.2shared.com/

How to input the file path in the specified text box or how to click
browse button without manually.


To click the "Browse" button try
ie.Document.all.Item("upField").Click

To click the "upload" button try
ie.Document.Forms("uploadForm").submit

....Ron

CellShocked

IE automation
 
On Sun, 25 Jul 2010 16:26:08 -0700 (PDT), ron wrote:

On Jul 25, 1:18*pm, muddan madhu wrote:
Ok.... I got similar site to test my requirement.

If you navigate to this webhttp://www.2shared.com/

How to input the file path in the specified text box or how to click
browse button without manually.


To click the "Browse" button try
ie.Document.all.Item("upField").Click

To click the "upload" button try
ie.Document.Forms("uploadForm").submit

...Ron


You are instructing someone on how to create a brute force password
tester.

Not a very good/bright move.


All times are GMT +1. The time now is 01:04 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com