How to interact with a "Browse for file..." pop-up window on a webpage?

[tnuis]

I made a macro that opens IE to a specific url and I want it to automatically upload a copy version of the current workbook where the macro is run from. This is normally done manually by clicking on a "Browse" button on the webpage which again opens a Browse for file window. Here you select a file or type the file path and click the button "OK". By the way i notice that this Browse for file windows is a built in OS window because if I do it on a mac it opens Finder.

Now, I can get the macro to do everything automatically up until the Browse window is opened, and then I loose all control. I have been trying to use the Sendkeys ("^v") to paste the path of the current workbook and then Sendkeys ("ENTER") to close the browse window again and select that file. These send keys do nothing. The strange thing is that if I just hit these key combinations on the keyboard manually then it pastes and click "OK".

Does anybody know how to fix this?

Please do ask for any information that you might need.


Skjermbilde 2013-11-29 kl. 14.28.42.jpg

Below you will find the relevant HTML code from that webpage (cannot give the page url as you would need a account):

And here is my macro:

Please Login or Register  to view this content.

[tnuis]

Nobody who knows this?

[tnuis]

Anyone?

Is this too complicated or do I explain it to bad...... Please do tell me.