Wrox Programmer Forums
|
Excel VBA Discuss using VBA for Excel programming.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Excel VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old May 2nd, 2007, 06:36 AM
Authorized User
 
Join Date: Mar 2006
Posts: 73
Thanks: 0
Thanked 0 Times in 0 Posts
Default IE Automation

here is a link to a previous post which almost solves my issue http://p2p.wrox.com/topic.asp?TOPIC_ID=43120

I am trying to enter the value for an element which is a filename. When I use the following it does not update this field..

Code:
Dim hCol As MSHTML.IHTMLElementCollection
Dim hInp As MSHTML.HTMLInputElement
...
Set hCol = hDoc.getElementsByTagName("input")
...
For Each hInp In hCol

    If hInp.ID = "upl-file" Then hInp.Value = "C:\temp.xls"

Next hInp
If the element is a text field then it updates just fine, but being a file it doesnt. PLease can someone let me know if they have an answer

 
Old May 3rd, 2007, 06:39 AM
Authorized User
 
Join Date: Mar 2006
Posts: 73
Thanks: 0
Thanked 0 Times in 0 Posts
Default

it seems you cant automate this. Just in case anyone was wondering

http://support.microsoft.com/default...;EN-US;Q266087






Similar Threads
Thread Thread Starter Forum Replies Last Post
IE automation kg8299 Excel VBA 3 June 8th, 2010 02:43 PM
automation ASCIIMAN Pro VB 6 1 January 29th, 2007 02:25 PM
automation! Khalifeh VB How-To 6 October 26th, 2006 12:45 PM
Excel Automation ameysun Pro VB 6 0 November 4th, 2004 02:55 AM
help with automation nicka Access VBA 1 December 12th, 2003 05:07 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.