VBA And Internet Explorer


Hi, I'm having some problems with the following - I have a WScript script written that logins into a password protected website and executes some things for me automatically. It used to work great when Internet Explorer used to accept http://username:password@domain.com but now it doesn't work very well for me - specifically:When the script is executed and login box comes up I'm using SendKeys to pass username/password - work fine when I'm executing the script manually, but once I set it to use with Scheduler it won't pass username/password to the login box, my guess is I need to make it "focus" on that login box... otherwise it passes username/password information to the IE itself and not the login. Any ideas?

View Answers
Very similar questions



How To Navigate In Internet Explorer With Macro www.mrexcel.com

Every day I gotta enter information in my work's website (intranet), however I dont know that much about manipulate with VBA the Internet Explorer application, for example once I enter information in the website, I gotta enter an ID after that I gotta select the date, then I gotta give some clicks in some checkboxes, then I copy some information from excel and enter that information in the navigator, and finally click on save. The thing is that I do not have access to that website in my home so is impossible for me to provide you with the link... what kind of codes do I need to do it, or where can I find a manual where I can learn to manipulate another application like the Internet explorer with VBA.

Need An Equivalent Code In Vb And Excel Vba www.vbforums.com

Hi,I use the following code in word vba to activate the Internet Explorer window.VB Code:Sub ActivateIE()If Tasks.Exists("Microsoft Internet Explorer") = True Then    With Tasks("Microsoft Internet Explorer")        .Activate        .WindowState = wdWindowStateMaximize    End WithElse    MsgBox "Microsoft Internet Explorer is not currently running."End IfEnd Sub It works fine in Word. But it is not working in vb and Excel vba.What is the equivalent code in vb and Excel?Thanks in advance.

VBA Control Internet Explorer File Download Box www.xtremevbtalk.com

Hi,I'm writing an excel vba code to automate a password-protected file download from the internet and got to the bit where I get the file download box to pop up. I'm just wondering how I can control the file download box on Internet Explorer so that I can save tha file as x in folder y.Thank you very much in advance.

VBA Excel/Internet Explorer Closing IE Password Dialog www.xtremevbtalk.com

From Excel, I am using application.navigate to go to an InternetExplorer window using an encypted userid/password (thanks, I learned how to do that from these forums ). The browser does find the page, the userid and password are recognized. My problem is that I cannot get rid of the password dialog window thru my code. Incidentally, my code opens two Internet Explorer windows - I don't know why.If I manually close the password dialog ("escape" or clicking the "x" at the top right corner) , my protected site opens. If I manually select "ok", the password dialogs persists. Those are manual selections - I cannot seem to programmatically get control of the password dialog box that Internet Explorer produces. I've tried "sendkeys" to no avail. Thanks, in advance!Code:Sub OpenSite()Dim URL As StringDim Flags As StringDim FrameName As StringDim PostData As StringDim Headers As String '64bit encrypted Userid : passwordDim security As StringDim appIE As InternetExplorerSet appIE = CreateObject("InternetExplorer.application")appIE.Visible = TrueWhile appIE.Busy DoEventsWendURL = "http://xxx.xxx.com/xxxxxx/xxx/"Flags = 0FrameName = "Null"PostData = "Null"security = "eXp0YmZjZjp5enRiZmNmMQ=="Headers = "Authorization: Basic " & security & Chr$("13") & Chr$("10")appIE.Navigate URL, Flags, FrameName, PostData, HeadersEnd SubNote: I've tried chr$() both with and without the ""

Excel VBA Automating Internet Explorer With User Interaction www.xtremevbtalk.com

This is my first post ever to an online forum... exciting. I'm an intermediate Excel VBA user. I have successfully used Excel VBA to automate IE before. The challenge I'm currently facing is that the site from which I need to cull data uses Flash and JavaScript on the index page, and if you attempt to go straight to the target URL, it redirects you to the index. For that matter, the target page changes URLs from day to day.Nonetheless, my [already rather computer-saavy] user needs somehow to get to the target URL, and needs to automate data retrieval from that target page.I hope to start a new instance of internet explorer, then allow the user to navigate to the page they need, then proceed with the rest of the automation. I'm thinking something like the following. What I'll need is that part in brackets. Anybody want to suggest a strategy? Many thanks!***Dim ie As InternetExplorerSet ie = New InternetExplorerie.Visible = TrueDo Until '[the user somehow indicates that this is the right page] DoEventsLoop'And then the rest of the subroutineSet ie = Nothing***

Excel VBA To Internet Explorer www.xtremevbtalk.com

Hi there.I'm new to this forum, and accendently found this place when trying to slove a excel vba problem. Here's the problem. I can open a Internet Explorer window through excel vba script and display an internet page. But what I need is a script/method to target a specific window. For example I have about 8 IE windows open, but when I run the script shown below it opens the target web page in a NEW window, or one of the other ones. What I'm trying to achieve is to open the target url in one of the existing window, a specific window.Just wondering if anyone knows if there is a property or method that I can use so that when I run the script I can get the url to open the correct window.Any hints of pointers would be greatly appreciated, or manybe I just need to know if this is possible.Thanks in advanced. James.I tried two methods so far.Method 1---------------------------Private Declare Function ShellExecute Lib "shell32.dll" Alias "ShellExecuteA" _ (ByVal hwnd As Long, ByVal lpOperation As String, ByVal lpFile As String, _ ByVal lpParameters As String, ByVal lpDirectory As String, _ ByVal nShowCmd As Long) As LongSub Macro8()'' Macro8 Macro' Macro recorded 22/08/2006 by template'' Keyboard Shortcut: Ctrl+d' Dim URL As String Dim test As String Dim resDim strP_id As String strP_id = Selection.Value URL = "http://james2/mac/2.asp?link=link"res = ShellExecute(0&, "open", URL, vbNullString, vbNullString, _ vbNormalFocus) End SubMethod 2---------------------------Sub DoBrowse1() Dim TargetFrame As String Dim ie As Object Set ie = CreateObject("Internetexplorer.Application") ie.Visible = True ie.Navigate "http://james2/vba_mac.html" End Sub

Excel 2000, VBA And Internet Explorer www.vbcity.com

Hello forum,I have a question regarding Excel 2000, Visual Basic for Apps and Internet Explorer. My question is this, I want to have a macro start IE after completion of a macro, and then go to a specific URL.Can someone explain this with a VBA code example?Regards,CoRrRan<Edit> typo </Edit> ----------------------------------------| --== Alta Alatis Patent ==-- |----------------------------------------Edited by - CoRrRan on 4/17/2002 6:07:02 AM

Open Internet Explorer www.xtremevbtalk.com

I am a newbie at VBA and I was looking at a way of opening up a page in internet explorer with a specific address and then copying some data and pasting this into excel. I have managed to create some code to open up internet explorer but dont know how to specify an address.Sub OpenFast()x = Shell("C:Program FilesInternet Exploreriexplore.exe", vbNormalNoFocus)AppActivate "Microsoft Excel"End Sub

Automating Internet Explorer With Office XP. www.access-programmers.co.uk

I�m thinking of starting to use office XP for a small system I have. My question is: Is office XP more compatible with internet explorer in terms of VBA automating? I have had to work around internet explorer quite a lot in office 97, and I haven�t been able to do what I want. Fuga.

Possible To Open Mozilla Firefox With VBA Script? www.mrexcel.com

I have a VBA code that will open an instance of Internet Explorer: Dim ie as object Set ie = CreateObject("InternetExplorer.Application") Can I use Mozilla Firefox instead of Internet Explorer? IE is giving me all sorts of issues when opening.


Automatically Control File Download Dialog www.ozgrid.com

complete the attached code (Excel VBA) to automatically process a File Download dialog from Internet Explorer. I want to click "Save" which will produce the "Save As" dialog. Then I need to enter a default filename like (C:Temp) and click "Save" again. When this is working, I will hide Internet Explorer to make the operation completely transparent to the user. The URL is a sample chosen specifically for this test case. Public Sub Report_Test() Dim objIE As SHDocVw.InternetExplorer Dim strURL As String Dim varItem As Variant ' Establish connection to the Internet Explorer application. Set objIE = CreateObject("InternetExplorer.Application") ' Set Internet Explorer visible. objIE.Visible = True

Webbrowser Question Hard www.vbcity.com

I have this program and what im tryin to do is this...In my Internet Explorer which is not in my vb form, I run my program and in my Internet Explorer im trying to do everything in my Internet Explorer but the code and everything is in the Vb program. i want the program to interact with the Internet Explorer that is open seperately. So im not using a webbrowser control, im using the Internet Explorer that is on my desktop. How do i do this? HELP

Simulating &"double Click&" On A Particular File To Run It www.vbforums.com

Hi all,i'm sure i've seen code to do this before but anyway...on my system i have VRML files (with extension ".wrl") and they are associated with internet explorer because i have a VRML plug-in for internet explorer.In File Explorer if i were to double click sample.wrl it will start internet explorer and load the VRML file (just like if you clicked on a html file it will open internet explorer - or whatever is your default browser).how do i simulate this "double click" from my vb program so that i can "run" a .wrl file?cheers,funky

Use Internet Explorer On IPad2? www.ipadforums.net

Would like to be able to use Internet Explorer for browser on IPad2 to utilize software that is only useable on Internet Explorer.

Like GOOGLE TOOL BAR IN THE IE(Internet Explorer) www.vbcity.com

Hai VBCity Members,                  How we can add our vb application in Internet Explorer (LIKE GOOGLE TOOL BAR IN THE INTERNET EXPLORER) .                  Thank You                                                                                                    L.Ganapathy

Sendkeys www.xtremevbtalk.com

I cant refresh my internet explorer browser Code:appactivate "Neopets - Tyrannia - Microsoft Internet Explorer provided by @home doeventssendkeys "^r"

Open A Website Using VBA/Excel www.xtremevbtalk.com

Guys (Girls?),I have found some code on this forum that works great to open a website from VBA, but since it does refer to Internet Explorer, I suppose it will not work if the user of my spreadsheet does have a different webbrowser on his/her computer than IE. Is there a universal way to open a website from within VBA with "the standard program associated with the .html file extention" or something?The code I am referring to is:Sub VisitWebsite()Dim ie As ObjectSet ie = CreateObject("INTERNETEXPLORER.APPLICATION")ie.NAVIGATE "http://websiteaddress"ie.Visible = TrueWhile ie.busyDoEventsWend End Sub

IE6 Automation In VBA - Open A (child) Page On Clicking A Button In Main (parent) www.mrexcel.com

My query is regarding internet explorer 6 automation via code in VBA (Excel 2003). I'm trying to open a page on clicking a button in main page. I'm able to open both parent and child pages via VBA, but now want to automate events (like radio btn click etc) in child page. below is my initial code - '======== Sub ListLinks() Dim IeApp As InternetExplorer Dim sURL As String Dim IeDoc As Object Dim i As Long 'Create new instance of IE Set IeApp = New InternetExplorer

Accessing Explorer Window Properties When Opening A PowerPoint Show In IE Window www.vbcity.com

Helllo!I am opening a PowerPoint Show inside an Internet Explorer window. (That is, on a simple html page, I have link to myfile.pps) I want a VBA macro in that presentation to access properties of the IE window, for example, the url. But I can't find anything in the VBA object browser that loks liekwhat I want.Does anyone out there know?Thanks.

No DirListBox In VBA www.xtremevbtalk.com

I've been looking around on the internet and it seems that the dirlistbox from vb isn't supported by vba.Does anyone have an idea on how to make something similar to this in vba, i mean choosing the directory with the explorer style.

Internet Explorer Has Stopped Working? forums.cnet.com

Internet explorer has stopped working, Internet explorer is restarting.windows explorer has stopped working, windows explorer is restarting. I have emailed Microsoft 3 times and they have given me MANY things to try but I am a computer tech, so I had already tried them all.It is all over the internet so my computer details should not matter.It is ALL over the Internet about this problem and no one seems to know the answer.Of course, you can format but that is not a "fix" for it or how to stop it from happening.

Internet Explorer Displays Blank White Page www.sevenforums.com

A new window opened in Internet Explorer displays a blank white page. I tried all these fixes: - Windows updates (Win 7sp1 and IE9.0.9) A new window opened in Internet Explorer displays a blank white page - Microsoft Fix it 50191 - Re-register the DLL Nothing happens when you click a link in Internet Explorer - Check your default web browser setting - Change the file types that Internet Explorer opens by default - Use the Internet Explorer No Add-ons mode - Reset Internet Explorer settings - Reregister the necessary Internet Explorer DLL files - Use System Restore The problem remains unsolved. Everything else runs fast and perfectly on my computer, included Mozilla Firefox. However I don't like when something doesn't run very well.

Create An IE Popup While In Firefox? forums.devshed.com

I'm currently promoting a website that requires internet explorer. I have been showing a page that tells non-IE users (mainly Firefox users) to switch to IE in order to view the page.However instead I want it so that if the current browser is not Internet Explorer it loads the website in Internet Explorer (basically a popup that is in Internet Explorer, and not in whatever browser the user is using).

General :: Internet Explorer Engine (not UA) For Android? forum.xda-developers.com

i wanna access websites which are internet explorer specific sites, they don't open correctly in firefox, chrome, safari, opera or any other browser,and i don't want just to change User Agent to desktop, it doesn't work. even on desktop pc those sites only work correctly on internet explorer. so is there anything to access those sites?one example of those sites is my phone network's free sms sending website, which can only be accessed correctly from internet explorer, so i can't send sms through my mobile from that site, i need to use internet explorer on my pc

Flash :: Unable To Install Adobe forums.adobe.com

I'm using windows 7 home premium and internet explorer 8. I've just downloaded adobe flash and tried to install several times but it gets to 99% then asks me to close internet explorer. But internet explorer IS closed. It will not let me continue, just keeps insisting i close internet explorer.

Internet Browser Class Name www.vbforums.com

I'm trying to create an object for the Internet explorer, i'm using VBA 6.2 on a third party piece of software.I can createobjects for word etc....set objWord = createobject("Word.application")but I'm don't know the class name for the internet browser.Can anyone help.

Protect Document www.vbcity.com

Hi,Is there a way to check if a word document is being "save" or "save as" in vba?also if we can disable the "save as" button in internet explorer the better...What i wanna do is to protect document from being save when they open in either word or internet explorerAnyone could help?

Download Zip File From Internet Explorer And Save It Into C Drive Using VBA Codes www.excelforum.com

How to download the zip file from internet explorer and save it into c: using VBA codes. I have tried many codes from the internet but none of them are working. i am facing problem for the popup box. the macro which i have found was not supporting to it. Please find the source data from my web page. [Code] ....

File Remains Open In Vba Background www.ozgrid.com

When I open a file in excel and I close it without closing excel-application, the file remains open in the Vba-background. This is not a big problem but when I reopen the file I get 2 versions in the Vba-explorer. This continues until I close the whole excel-application. So everytime I reopen the file the vba-explorer adds a new version. Is somebody familiar with this? Is this normal or is this a bug?

Internet Explorer Object - Tell Webbrowser Control To "quit" Or Destroy It Self? www.vbforums.com

In VB6 I used internet explorer object a lot. There things internet explorer object can do that webbrowser control cannot. For example, internet explorer object is easier to debug because when the application is in debug mode, internet explorer object is still interactive with client. Also we can clear cookies and resstart with internet explorer object. We can do ie.quit, then set ie=new internetexplorer then ie.visible=true In vb.net internet explorer object becomes webbrowser control and I have no way to do that? How can I delete cookies and then restart webbrowser control? How can I tell webbrowser control to "quit" or destroy it self? That sort of thing.

VS 2010 Update Internet Explorer In Program? www.vbforums.com

I have a small webbrowser but when I try to navigate to a certain webpages the webpage show a warning to force me to upgrade my webbrowser also internet explorer:"Upgrade your browser for a better Myspace experience.We recommend one of the following browsers to provide the best and most reliable experience on Myspace. Some features, like Profile 2.0 and MyspaceIM for Web, may not have full functionality in other browsers.select and install one of the browsers below."I already have internet explorer 9 installed in my computer also the webpage show the message:"Microsoft Internet Explorer Available for Windows Already using Internet Explorer 9? Please visit �Settings�, and select �f12 Developer Tools�. In this window, make sure "Browser Mode" is set to �Internet Explorer 9� and "Document Mode" is set to �Internet Explorer 9 standards�"

Internet Explorer www.xtremevbtalk.com

HiI was planning on making an internet explorer equivilant in visual basic using the Microsoft Internet Control. If you make an internet explorer in VB and run it, when you right hand click and say new window, it loads in a new Internet Explorer Window, how do you make it load in your own new window?Thank you KindlyAdam

Highlighted Text In Internet Explorer www.xtremevbtalk.com

hi ...i hope anyone can help me with this problem ...iam trying to make a small app. that will get only the highlighted text in internet explorer ... is this possible !?i will add a timer that will check for the forground window, and then get the highlighted text ...the app will only be used to get highlighted text from internet explorer ...can anyone please help !?ahh, i won`t be using the "Microsoft internet controls" ...the internet explorer window will be opened seperatley ..thanks guys for your help ..

Visual Studio Takes A Long Time To Run After I Press F5? forums.asp.net

why vs takes a long time to run after i press F5. The below are the output which requires me to wait for about 40seconds To enable script debugging in Internet Explorer, choose Internet Options from the Tools menu and navigate to the Advanced tab. Under the Browsing category, clear the 'Disable Script Debugging (Internet Explorer)' checkbox, then restart Internet Explorer. 'WebDev.WebServer.EXE' (Managed): Loaded 'C:WINDOWSassemblyGAC_32mscorlib2.0.0.0__b77a5c561934e089mscorlib.dll' 'WebDev.WebServer.EXE' (Managed): Loaded 'C:Program FilesCommon FilesMicrosoft SharedDevServer9.0WebDev.WebServer.EXE' [code]....

SSRS-2000 Export To Excel Error-Please Help social.msdn.microsoft.com

When we are trying use�the �export to excel feature on�some �Reports� we are getting the following error � First for the open,save File Download� Dialog box it is neither showing the file name nor the file type� and if clicking open/save�we are getting the following Microsoft Internet Explorer error message saying � Internet explorer cannot down load from Servername � Internet explorer was not able to open this internet site.The requested site is either� unavailable or cannot be found.Please try again later � � Thanks for the reply � Rajesh � � �

Web Page Property www.vbforums.com

I already have some VBA code that uses an id let’s call it “id666″ to get information from a website using custom code without using internet explorer. The website has 1000s of pages, and each one relates to a different id.You can see the id value when you right click on a web page window and choose “properties”. It’s part of the "Address: (URL)" property eg http://www.thiswebsite.com/MarketVie...rigin=HFL&ex=1What I want to do is access the value held in “Address: (URL)” of an already open web page, then extract the id, then use my existing code to extract the data for the id.Unfortunately my cunning plan is not working out, because I can't retrieve this "Address: (URL)" property using VBA.I’ve written some code that identifies the internet explorer object and document object of the web page, but all the URL type properties I’ve tried just give the url as “www.thiswebsite.com” without the id . Am I on the right track? How do I access the “Address: (URL)” value displayed on the properties page?

File Locking Conflict When Create HTML Page www.vbforums.com

I am using VBA within Excel2003. The VBA creates an HTM version of my spreadsheet page, using commands as shown below. Set rngConvert = wrkFile1("NH_PROD.xls").ActiveSheet.Range("a1:h84") strHTMFilePath = "\NR-fp06GroupsSHARENH_PROD1.htm" intResult = htmlconvert(rngConvert, False, False, _ False, 1252, strHTMFilePath) The problem is that when the VB is run, it should always overwrite the old HTM file with the new file. (Note: the HTM file is always in use, open 24 hours a day, 7 days a week and being displayed by Internet Explorer. Internet Explorer is occasionally refreshed, which reloads the page and the problem with content is then seen) However, sometimes when the VB is run it just appends the new HTML content to the end of the old HTML content, giving me a webpage that is twice as long as it should be, with a mix of old and new content! I always want the new HTM file to completely overwrite the old HTM file. I think I have a "file locking conflict" (?) What code snippet can I use to resolve this? Thanks

File Locking Conflict When Creating .HTM www.codeguru.com

I am using VBA within Excel2003. The VBA creates an HTM version of my spreadsheet page, using commands as shown below.Set rngConvert = wrkFile1("NH_PROD.xls").ActiveSheet.Range("a1:h84")strHTMFilePath = "\NR-fp06GroupsSHARENH_PROD1.htm"intResult = htmlconvert(rngConvert, False, False, _False, 1252, strHTMFilePath)The problem is that when the VB is run, it should always overwrite the old HTM file with the new file. (Note: the HTM file is always in use, open 24 hours a day, 7 days a week and being displayed by Internet Explorer. Internet Explorer is occasionally refreshed, which reloads the page and the problem with content is then seen) However, sometimes when the VB is run it just appends the new HTML content to the end of the old HTML content, giving me a webpage that is twice as long as it should be, with a mix of old and new content! I always want the new HTM file to completely overwrite the old HTM file. I think I have a "file locking conflict" (?) What code snippet can I use to resolve this? Thanks

HP Networking :: Pavilion Dv7 - Blue Screen On Laptop With Internet Explorer? h30434.www3.hp.com

I have a Windows 7 HP Pavilion dv7. I can use the internet 2 different ways - through AOL or through Internet Explorer. It works fine going through AOL. But when I go directly thru Internet Explorer, I get the dreaded Blue Screen. I have gotten a messsage to upgrade to Internet Explorer 11, but when I try to do that, I get the Blue Screen.

Internet Explorer Is Not Working? www.sevenforums.com

my internet explorer was working a few days ago, then i logged off and logged back in and it wont display any pages and says if i would like to start a diagnostics test, and when i do it says everything is fine and it cant find the problem anywhere on the internet. But my internet explorer 64 bit works, my Normal Internet explorer or 32 bit is not. I am using XP not vista.

Fedora Networking :: Cannot Open Internet On Core 13 forums.fedoraforum.org

I have PC dual boot one for winxp and another for fedora core 13 I installed USB wireless adapter type rtl8187 : 1-In winxp configured properly and I made internet connection broadband type and the internet explorer working fine. 2-In Fedoracore 13 also the USB wireless adapter configured automatically and it show all the wireless station and also I can ping the Gateway address but the internet explorer not working ,I use Mozilla firefox explorer. how can I setup the internet connection?

Close All Explorer Windows www.vbforums.com

Hello,I was wondering how I could go about closing all open Internet Explorer windows and regular Explorer windows when I user clicks a button?Thanks,Justin Sampson

Creating A Directory Structure Using VBA And Form forums.aspfree.com

Hello, Just want to know how to create a directory structure using VBA and a form in Windows explorer, thanks for any help...

How Can I Know User Visited A Site Using Windows Explorer( Not Internet Explorer) www.vbcity.com

I have made a program which keep track of site visited by users through internet explorer but I am unable to get it when user visited it through windows explorer. can I get any function which gives the information when user visited a site using windows explorer or whether it's possible to stop user to visit a site using windows explorer he will only visit a site using internet explorer only.Please help me out .Thanks

Block Access To Websites? www.bleepingcomputer.com

i have a computer with windows 7 home premium and internet explorer 9 i have a user account set up that i want to block access to various web pages.in internet explorer i click on tools>internet options>security, select restricted sites and click on sites.i add [url] to my list of restricted sites.after logging off and logging on again i'm still able to access Internet.i click on tools>internet options>content and click on enable in the content advisor section.i click on the approved sites tab and add www.Internet.com and select never.after quitting ie, logging out, logging back in, i can still access Internet.

API URLDownLoadToFileA Uses Browser Cache Settings www.xtremevbtalk.com

Using Excel 2003 VBA, but applies to all forms of VBI fought this problem for weeks, trying to fetch live changing data from a server but always getting stale old files. This morning I discovered the problem and then found a solution.This API caches in the Internet Explorer cache according to the settings ofTools > Internet Options > General tab > Temporary Internet files area > Settings > "Check for newer versions of stored pages:"With most computers at the default setting "Automatically", the API will cough up what it finds in the cache rather than deliver a fresh file from the server. I think I've observed a TTL on the files of a day or two, but nothing acceptable for moving live data.You can fix the problem by changing the setting to "Every visit to the page", but who'd want to depend on this? Not me so I Googled around and found this solution:http://vbnet.mvps.org/index.html?cod...ilenocache.htmI also found one post on this forum that mentions this cache phenomenon, and suggested using Internet Transfer Control. I'd like to try this but I couldn't find a way to implement it under Excel VBA.http://www.xtremevbtalk.com/showthre...942#post868942I hope this post will save someone a little time and frustration.Pete