Upload a file to a web page with VBA

[Juan Fonseca]

Best regards to everyone, I am trying to automate the process of uploading some documents to a web platform.

I already know how to click on the "browse" button that appears on the page to upload the files knowing its ID (I use IE.document.getElementById ("Browse_Button"). Click), but here a window opens to search and select the file to upload; and it is at this point where I do not know how to automate the search for the document (I already have the path saved in a string filepath) within the window that opens and finally click on the "upload file" button of said window.


I appreciate you could help me with the part of the code and / or the explanation of the commands to manage it within this search window.

 

[John_w]

You can upload a file using VBA by automating the web page's HTML form with IE:

Automated file upload using IE, without user interaction - VBA

Lets you send file from a client to www server over http connection using IE. The file is sent as a result of type=file form field.

www.motobit.com

Look in the HTML for the form with an input tag of type=file to determine the field name you must specify in the Content-Disposition header.