Excelguru.ca - Powered by vBulletin
  • Register
  • Help

  • Home
  • Products & Services
    • Live Training
    • Video Courses
    • Monkey Tools Add-in
    • Books & Other Products
    • Private Courses
    • Consulting & Mentoring
    • Training Calendar
    • Affiliate Sales Program
    • About Us
    • Today's Posts
    • FAQ
    • Calendar
    • Community
      • Member List
    • Forum Actions
      • Mark Forums Read
    • Quick Links
      • View Site Leaders
  • Blog
  • Forum
    • Excelguru Forums
    • What's New?
    • Today's Posts
    • Forum Guide
    • Forum FAQ
    • Supported BB Code Tags
  • Resources
    • Online Training
    • Recommended Books
    • Add-ins & Tools
    • Excel Blogs
    • Useful Links
  • Knowledge Base
  • Contact Us
  • Advanced Search
  • Home
  • Home
  • Knowledge Base Articles

  1. If this is your first visit, then welcome! Be sure to check out the FAQ by clicking the link above.
    Register here so that you can post in the forums or comment on the articles.

  • Monkey Tools
  • Knowledge Base Articles By Category

    Access - ADO (4)
    Access - SQL (4)
    Access - VBA Programming (10)
    Downloads - Games (1)
    Downloads - Learning Aids (11)
    Downloads - Utilities (9)
    Excel - ADO (4)
    Excel - Charts and Data Visualization (1)
    Excel - Formulas (8)
    Excel - General Tips (36)
    Excel - Interactive Pages (9)
    Excel - PivotTables (12)
    Excel - Power Query (3)
    Excel - PowerPivot (7)
    Excel - SQL (4)
    Excel - UDF (7)
    Excel - User Interface Customization (2)
    Excel - VBA Programming (49)
    Excel - WebApp (4)
    Internet Explorer - VBA Programming (1)
    Novell Groupwise - VBA Programming (2)
    Other - General (1)
    Outlook - General Tips (5)
    Outlook - VBA Programming (7)
    PDF Creator - VBA Programming (11)
    Power BI (3)
    PowerPoint - VBA Programming (7)
    Publisher - VBA Programming (7)
    Syndicated Articles (7)
    Training Products (10)
    Word - VBA Programming (8)
  • Internet Explorer - VBA Programming

    Examples Of Using Late Binding To Connect To Internet Explorer 

    by
    Ken Puls
    • View Profile
    • View Forum Posts
    • View Blog Entries
    • Visit Homepage
    • View Articles
    Published on 2006-02-22 06:56 AM     Number of Views: 20690 

    Introduction:
    This article contains an example of using late binding to create a new instance of Internet Explorer.

    Please note that you can copy these code examples into any application that supports VBA, but the called application must be installed on your system for it to work. Just copy them into a standard module and run them. (No references need to be set in the Visual Basic Editor in order to make this code work.)

    Create a New instance ...
    Read More Read More
  • MVP Logo
  • Recent Forum Posts

    AliGW

    Tracking numbers in a row & counting them in columns

    Try this one in I5 copied across and down:

    =SUMPRODUCT(COUNTIF($H5:$K5,S$5:S$13))



    =MAX(range) simply finds the...

    AliGW Today, 05:32 PM Go to last post
    ExcelHelpNeeded

    Tracking numbers in a row & counting them in columns

    Ali what you did was perfect and brilliant and I have a use for those numbers in that order.

    How would the formula be different if my numbers...

    ExcelHelpNeeded Today, 04:51 PM Go to last post
    ExcelHelpNeeded

    Tracking numbers in a row & counting them in columns

    That is brilliant! I was making this soooo much more complicated. I have never used or even seen the &MIN and &MAX though. Can you explain how...

    ExcelHelpNeeded Today, 03:34 PM Go to last post
    pinarello

    differences between Excel.workbook... and ~.CurrentWorkbook function

    I have now adapted the workaround "Calculation of duration" so that it can be used directly for the import from a workbook as well as for the...

    pinarello Today, 02:51 PM Go to last post
    AliGW

    Tracking numbers in a row & counting them in columns

    One way!

    In I5 copied across and down:

    =COUNTIFS($C5:$F5,">="&MIN(N$5:N$13),$C5:$F5,"...

    AliGW Today, 08:36 AM Go to last post
  • Contact Us
  • Excelguru Forums
  • Archive
  • Top
All times are GMT +1. The time now is 07:25 PM.
Powered by vBulletin® Version 4.2.5
Copyright © 2021 vBulletin Solutions Inc. All rights reserved.
Pre-Defined Posts provided by Post Templates v1.6.1pl1 (Free) - vBulletin Mods & Addons Copyright © 2021 DragonByte Technologies Ltd.
Thread / Post Bookmarks provided by Thread / Post Bookmarking v1.2.0 (Free) - vBulletin Mods & Addons Copyright © 2021 DragonByte Technologies Ltd.
Copyright © 2004 - by Excelguru Consulting Inc.
Gravatar by 1e2.it