ExcelBanter - IE Automation

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - IE Automation (https://www.excelbanter.com/excel-programming/443394-ie-automation.html)

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"

On Jul 23, 4:27*pm, "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"

I'm sorry but as far as I know it just isn't possible to enter a value
into that type of input, and believe me I've tried.