PDA

View Full Version : Automate File Browse in IE



CD Lung
10-07-2011, 05:30 PM
Here is my situation. I currently have an excel macro that formats a set of data, saves it as a particular CSV file and then automatically opens Internet Explorer and navigates to a particular webpage. On this webpage I have to upload the previously created CSV file daily. What code would I use that would automatically browse for my particular file and upload it without me having to click on the browse button, click on my file, click ok, then click upload. Anyones help would be appreciated

Crocus Crow
10-13-2011, 04:57 AM
Assuming the web page uses a HTML form to manually upload a file, you can automate this using VBA and IE - see http://www.motobit.com/tips/detpg_uploadvbaie/