By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,594 Members | 2,062 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,594 IT Pros & Developers. It's quick & easy.

VBA calling IE with credentials

P: 1
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
Nov 28 '07 #1
Share this Question
Share on Google+
1 Reply


Plater
Expert 5K+
P: 7,872
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
Nov 28 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.