Automate File Upload

Hi,

I am trying to automate uploading a weekly file to a secure file transfer .aspx site.
I have all fields completed except for the type="file" field which will not allow to be filled with VBA.

I have tried the following with no sucess:
Set FLE = appIE.Document.getElementsByName("FileUpload1")
FLE(0).Value = "C:\Weekly_File.xls"

My hope is that I might be able to enter this file name with a different type of coding. I downloaded iMacros for IE and the step it uses to load the file is this code:
TYPE=INPUT:FILE FORM=NAME:FormDefault ATTR=ID:FileUpload1 CONTENT=C:\Weekly_File.xls

Is there a way I could run this line of code from VBA?

Any help is populating this field is appreciated.

Thank you

For what it's worth I've never found a reliable way round this (and I've spent a while looking), that type of input is deliberately designed to stop automation from the browser so the user knows what they are uploading.

I'm not saying it can't be done, just a pain

Actually, just had another look, this looks quite promising - could it work for you?

http://www.motobit.com/tips/detpg_uploadvbaie/

I saw this earlier but I don't understand it. It is described like a good way to send the file, but I also need to select people to email from the .aspx site. Not sure it will work for me.

Thanks for looking, I have spend a month looking too and have come up short, hence the post here.