VBA calling IE with credentials

[Clarky1062]

I am using the VBA thats part of Excel. I am getting files that are shared on another network computer in "\\ip.add.re.ss\Directory" Unfortunately that computer has its own log in. And when you connect through Excel it errors. If you type that into an address bar in IE the standard windows user/password dialogue opens. I know that i can do this:

shell("C:\Program Files\Internet Explorer\iexplore.exe \\ip.add.re.ss\Directory")

and it will open the IE window and bring up the dialogue for the user to type in.

Is there a way to include the login credentials in the call line so the user wont have to type it in everytime?

Also, is there a way to suspend the rest of the VBA code until this is completed, besides setting a timer?

Thanks All

Ryan

[Plater]

Hi,

I'm moved your thread to the (hopefully) more appropriate forum section: Visual Basic.
I've also edited your title to include potentially helpfull keyword(s), so that the experts of the area have a better idea of what you are looking for, right from the start.

Good luck!

MODERATOR