VBA and IE

[Centrican]

Ok here's my problem - I want to use a VBA excel macro to open up IE and upload files to our corporate intranet site. Now I could do this with sendkeys but of course I don't want to...

My question is; can I use a VB command on a open file window (opened when you click browse to select the file to upload) to go directly to the location and select a file of my choice? If so, what command do I use? I'd imagined using sendkeys to open this window - however it's a named item on the HTML document so I'd guess I can send a variable to it. Do I do this the same way as to a textbox?

I've not built the system yet so don't worry about being vague in responses (the question's pretty vague anyway). Just wondering which direction to take.

Cheers.

 

[moneytastesbad]

I think this will open IE and navigate to the page you want to go to

Set ie = CreateObject("InternetExplorer.Application")

With ie
  .Visible = True
  .navigate   "http://www.yourwebsite.com"

[/code]

 

[Centrican]

Yep, that will do that. However it's the code once I've gone to the correct page that I need to know about.

Is there a command to use a named "browse" button on an uploader to open a specific file?