Excelguru.ca - Powered by vBulletin
  • Register
  • Help
  • The Facebook Platform

  • Knowledge Base
    • Today's Posts
    • FAQ
    • Calendar
    • Community
      • Member List
    • Forum Actions
      • Mark Forums Read
    • Quick Links
      • View Site Leaders
  • Blog
  • Forum
  • Forum Tools
    • What's New?
    • Today's Posts
  • Courses
    • Excelguru e-Learning Catalog
    • The Magic of PivotTables (2003)
    • The Magic of PivotTables (2007)
    • The Magic of PivotTables (2010)
    • Instructor Led Training
    • Sell Excelguru Courses On Your Site
  • Resources
    • Excelguru e-Learning Catalog
    • Books
    • Charting & Dashboarding Resources
    • Useful Add-ins and Tools
    • Other Forums
    • Excel Blogs
    • Useful Links
    • Excel Training Calendar
    • Consulting
    • Sales Affiliate Program
  • FAQ
    • FAQ Index
    • General Forum Usage
    • Reading and Posting Messages
    • Supported BB Code Tags
    • Multi Forum Posting Policy
  • About
    • About Me
    • Awards
    • Testimonials
    • Contact Me
  • 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.

  • Knowledge Base Articles By Category

    Access - ADO (4)
    Access - SQL (4)
    Access - VBA Programming (10)
    Downloads - Games (1)
    Downloads - Learning Aids (11)
    Downloads - Utilities (6)
    Excel - ADO (4)
    Excel - Charts and Data Visualization (1)
    Excel - Formulas (8)
    Excel - General Tips (36)
    Excel - Interactive Pages (9)
    Excel - PivotTables (11)
    Excel - PowerPivot (6)
    Excel - SQL (4)
    Excel - UDF (7)
    Excel - User Interface Customization (2)
    Excel - VBA Programming (48)
    Excel - WebApp (4)
    Internet Explorer - VBA Programming (1)
    Novell Groupwise - VBA Programming (2)
    Other - General (0)
    Outlook - General Tips (5)
    Outlook - VBA Programming (7)
    PDF Creator - VBA Programming (11)
    PowerPoint - VBA Programming (7)
    Publisher - VBA Programming (7)
    Syndicated Articles (7)
    Training Products (3)
    Word - VBA Programming (8)
  • Learn how to create Excel dashboards.
  • 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-23 04:52 AM     Number of Views: 3863 

    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 1 Comment

    Security In Microsoft Office 

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

    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 verions 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 warnigns 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 06:24 AM     Number of Views: 1889 

    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 05:56 AM     Number of Views: 3510 

    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 06:10 AM     Number of Views: 5979 

    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 06:36 AM     Number of Views: 2356 

    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

    JeffreyWeir

    Creating formulas & Macros

    Try the attached file, and let me know if it suits.

    Note that I'm using Excel Tables (new in Excel 2007) and data validation to do this....

    JeffreyWeir Today, 02:26 AM Go to last post
    JeffreyWeir

    Help required for League Table data entry

    1:30am is prime poker playing time.
    Here's the cause of the problem:
    The formula in cell AC4 is hard coded to refer to your initial table...

    JeffreyWeir Today, 02:01 AM Go to last post
    Brian Thomas

    Help required for League Table data entry

    Many thanks for your efforts today NBVC and Jeffrey. I have to sleep now, it's 1.30am here and I have to be up early. I'll get back to you tomorrow ...

    Brian Thomas Today, 01:39 AM Go to last post
    JeffreyWeir

    Help required for League Table data entry

    Okay, I'll take a look....

    JeffreyWeir Today, 01:17 AM Go to last post
    Brian Thomas

    Help required for League Table data entry

    Yep, all is fine bar that....

    Brian Thomas Today, 01:17 AM Go to last post
  • Contact Us
  • Excelguru Forums
  • Archive
  • Top
All times are GMT +1. The time now is 03:06 AM.
Powered by vBulletin® Version 4.2.0
Copyright © 2013 vBulletin Solutions, Inc. All rights reserved.
Thread / Post Bookmarking by Thread / Post Bookmarking v1.1.0 - vBulletin Mods & Addons Copyright © 2013 DragonByte Technologies Ltd. Runs best on HiVelocity Hosting.
Copyright © 2004-current by Ken Puls
Gravatar by 1e2.it