Choosing a file to upload on IE with Excel VBA?

Like the title says, I have been stuck on finding a way to select a file I want to upload to a website.

Unfortunately I cannot copy/paste a file path into a text box and then click the upload button. Instead, the website forces me to click a Choose file/Browse button which then opens up my directory (just like Application.GetOpenFileName). This appears to be done using a javascript function, but I have no idea how to execute the function with VBA. Here is that part of the html:

Please Login or Register  to view this content.

I know this may be taking VBA to the fringe of what it's meant for, but if anyone has any suggestions that would be great.

You can't do this by automating IE, it's a security feature.

You'll have to either post it directly to the server (which requires a working knowledge of http requests) or give it up as a bad job I'm afraid.

Originally Posted by Kyle123

You can't do this by automating IE, it's a security feature.

You'll have to either post it directly to the server (which requires a working knowledge of http requests) or give it up as a bad job I'm afraid.

I see.. is this true of all javascript functions or is there something in particular about this one that led you to believe it's for security purposes? Thanks for the response

It's not JavaScript it's a feature of the File upload HTML control

Originally Posted by Kyle123

It's not JavaScript it's a feature of the File upload HTML control

Interesting...did you figure it out from those 2 lines of html or is this a general rule? Are you referring to the actual upload or just selecting the file? I was really under the impression that <script src="http://js-sourceexample.com/ab-999.min.js"></script> is what opened the directory and allowed you to select the file.

No, I didn't need to, JavaScript can't read files from your computer, it must use an HTML File control for that and that's the bit you'd need to automate (which you can't)