New Excel Forum

This forum has been moved to TeachExcel.com

Ask all future questions in the New Excel Forum.

ExcelKey

Use VBA to fill in IE dialog box to upload a file

Macros, VBA, Excel Automation, etc.

Use VBA to fill in IE dialog box to upload a file

Postby Rahulm123 » Sat Apr 30, 2016 1:25 am

I'm required to automate below steps for an upload file option on IE browser using VBA 6.5

1) Click on browse button - done
HTML tag which is opening the file upload dialog box
Code: Select all
<input name="file" id="file" onkeypress="return false" onchange="RALLY.ui.Attachment.uploadAttachment();" type="file" size="40"/>


2) A windows file upload dialog box opens. File path needs to be copied into File name field. - not done
3) Click enter/open to upload the file. - not done

I've tried using Sendkeys, its not working.
Looking for a solution for step 2 & 3.

Thanks,
RahulM
  • 0

Rahulm123
Rookie
 
Posts: 1
Joined: Apr 30, 2016
Reputation: 0
Excel Version: 2007

Return to Macros and VBA Questions

Who is online

Users browsing this forum: Google [Bot] and 37 guests

cron