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)
  • Outlook - VBA Programming

    Easy Outlook Email Integration 

    by
    Ken Puls
    • View Profile
    • View Forum Posts
    • View Blog Entries
    • Visit Homepage
    • View Articles
    Published on 2012-01-22 05:52 AM     Number of Views: 35783 

    Over several years of participating in forums, and working on my own projects, I always felt it was a bit awkward to create and send new emails through Excel. Invariably, every time I found that I needed email code, I ended up heading off to a site to copy an example (usually from my colleague Ron de Bruin's excellent site), then customizing to make it work.

    The goal of this article is to provide an even easier way to add email functionality to your Excel (or any other Office) project... something easy enough for beginner coders to use as effectively as master coders. I wanted a re-usuable chunk that I could just drop into my project with ease, and I believe I've accomplished that here.
    ...
    Read More Read More 3 Comments

    Security In Microsoft Office 

    by
    Ken Puls
    • View Profile
    • View Forum Posts
    • View Blog Entries
    • Visit Homepage
    • View Articles
    Published on 2011-05-05 06:13 AM     Number of Views: 31567 

    Please Note: This text is the complete reproduction of Chapter 17 - Security if Microsoft Office from my book RibbonX: Customizing the Office 2007 Ribbon, and is reproduced with permission of Wiley Publishing who retains the copyright of this work.




    This chapter was obviously written for Excel 2007, and still holds true for Office 2010.

    In addition, this chapter also discusses macro security applicable to Office 97 through Office 2003. Key portions to read for these versions are Security Prior to Office 2007 and Digital Certificates. While some of the screens may look a little different, they should be close enough to help you understand how to set up a SelfCert digital certificate and add it to your projects. These steps will allow you to avoid macro warnings in your programming environment, without having to sacrifice security by setting your security levels to low. ...
    Read More Read More

    Controlling When Application Properties Are Toggled and Controlling Events 

    by
    Ken Puls
    • View Profile
    • View Forum Posts
    • View Blog Entries
    • Visit Homepage
    • View Articles
    Published on 2006-08-26 07:24 AM     Number of Views: 19343 

    This article actually covers two topics. The first is on controlling when application properties are toggled, and the second shows how to adapt that methodology into a superior method to manage events and prevent recursive calls. The first example set is purely based on Excel, but the methodology can be easily adpated to other applications. The second example is based on an userform and is not application specific.
    ...
    Read More Read More

    Send Email Using ClickYes 

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

    Introduction
    Every now and then, you may need to send an email from another application through Outlook. If you've ever thought about automating this process using Outlook 2000, Outlook 2002 or Outlook 2003, then no doubt you've run into the dreaded Outlook security prompt upon trying to send ...
    Read More Read More

    A Discussion On Early vs Late Binding 

    by
    Ken Puls
    • View Profile
    • View Forum Posts
    • View Blog Entries
    • Visit Homepage
    • View Articles
    Published on 2006-04-11 07:10 AM     Number of Views: 33144 

    What is "Binding"?
    "Binding" is essentially the process of connecting to the object model of an application to make use of its objects, properties and methods. There are two methods to accomplish this: Early Binding and Late Binding. ...
    Read More Read More

    Connecting To/Creating A New Application Instance Via Late Binding 

    by
    Ken Puls
    • View Profile
    • View Forum Posts
    • View Blog Entries
    • Visit Homepage
    • View Articles
    Published on 2006-01-16 07:36 AM     Number of Views: 20912 

    Introduction:
    There are actually two different ways to accomplish this task, depending on exactly what you want to do. You can:
    • Connect to an existing application (uses the GetObject method)
    • Create a new application with no document loaded (uses the CreateObject method)

    Please note that while all of this code was written to control Microsoft Word from Excel, you can use it in any other VBA enabled application, and you can also use it to control any other VBA enabled application, simply by changing "Word" to Excel, Powerpoint, Access, etc... in the examples below.
    ...
    Read More Read More
  • MVP Logo
  • Recent Forum Posts

    AliGW

    Help creating a VLookup to retrieve training status

    Administrative Note:

    Welcome to the forum.

    We would very much like to help you with your query, however it has been brought...

    AliGW Today, 10:05 AM Go to last post
    Pecoflyer

    Get value form a table

    Hi
    please post a sample sheet ( no pics please) Thx...

    Pecoflyer Today, 08:51 AM Go to last post
    Docharding

    Help creating a VLookup to retrieve training status

    In B2 =VLOOKUP(A2;Report!1:1048576;15;0), if I understand what you are trying to achieve

    Sent from my SM-G965F using Tapatalk...

    Docharding Yesterday, 11:26 PM Go to last post
    Ignatios

    Get value form a table

    Hi gents,
    I am trying to find the correct syntax/formula for getting a value from a table based on a value from another cell in an other sheet....

    Ignatios Yesterday, 10:02 PM Go to last post
    alansidman

    Best method to create training log?

    Follow up to Ali's suggestion. Here is a link that I often refer Access Template Lookers to examine. While it does not give you an actual DB, it does...

    alansidman Yesterday, 05:54 AM Go to last post
  • Contact Us
  • Excelguru Forums
  • Archive
  • Top
All times are GMT +1. The time now is 10:17 AM.
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