IE automation

  • Thread starter Thread starter fi.or.jp.de
  • Start date Start date
F

fi.or.jp.de

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

<label>Spreadsheet:</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"
 
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''''''''''''''''''

<label>Spreadsheet:</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
 
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.
 
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
 
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.
 
Back
Top