VBA IE Automation - Clicking Browse Files Button

[Legacy 185660]

Hi!
So I'm currently creating some VBA to automate IE, I have VBA to open a webpage, insert data, and it all works fine. To make it better, I also want to automate file uploads where VBA fills out the entire form, then presses the button to get the select files dialog for the user to enter in the files.

I've tried for hours, but I can't figure out how to click the button.

Any ideas?

Since I can't paste HTML here without it messing up the actual post, the code is:
http://dl.dropbox.com/u/66903141/HTML Button.txt

and if that can;t be done, the secondary choice is to click this button (although I'd prefer the first way):

< input type="file" name="u" size="40" style="width:500px" / > (i've added spaces so it will display the HTML code)

 

[John_w]

Since I can't paste HTML here without it messing up the actual post, the code is:
http://dl.dropbox.com/u/66903141/HTML Button.txt

The HTML should post correctly if you put it inside HTML tags. That HTML is a Flash uploader; I don't think I've seen any code to automate this type of upload and I would need to see the entire HTML and the web page itself to say more.

and if that can;t be done, the secondary choice is to click this button (although I'd prefer the first way):

<input type="file" name="u" size="40" style="width:500px" />

See Automated file upload using IE, without user interaction - VBA and Automatic file upload using IE+ADO without user interaction - VBSscript. Basically, you have to build the multipart/form-data string including the file bytes and send the whole lot in a HTTP POST request.

 

[Legacy 185660]

The HTML should post correctly if you put it inside HTML tags. That HTML is a Flash uploader; I don't think I've seen any code to automate this type of upload and I would need to see the entire HTML and the web page itself to say more.

Kijiji : Post an Ad
There it is! I think it would be enough if I could just click the button and allow for use input.

See Automated file upload using IE, without user interaction - VBA and Automatic file upload using IE+ADO without user interaction - VBSscript. Basically, you have to build the multipart/form-data string including the file bytes and send the whole lot in a HTTP POST request.

Kijiji : Post an Ad
I was looking at that yesterday for a while, but I couldn't figure out how to actually create the entire HTTP post request. I couldn't find any other examples