Excelguru.ca - Powered by vBulletin
  • Register
  • Help

  • Home
  • Products & Services
    • Live Training
    • Video Courses
    • Private Courses
    • Consulting & Mentoring
    • Training Calendar
    • Books
    • 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.

  • 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)
  • Excel - UDF

    Count Files (with a specific extension or not) in a folder and subfolders 

    by
    Ken Puls
    • View Profile
    • View Forum Posts
    • View Blog Entries
    • Visit Homepage
    • View Articles
    Published on 2009-10-14 09:15 AM     Number of Views: 24178 

    Introduction:
    This macro can be used to count how many files exist in a folder and subfolders. In addition, if passed the file extension, it can also be used to count only files of a specific type. (For example "xls" files.) If you are looking for a macro that counts files within a specific folder only (ignoring subfolders), please see this entry.
    ...
    Read More Read More 2 Comments

    Count Files (with a specific extension or not) in a Folder 

    by
    Ken Puls
    • View Profile
    • View Forum Posts
    • View Blog Entries
    • Visit Homepage
    • View Articles
    Published on 2008-03-02 09:21 AM     Number of Views: 53395 

    Introduction:
    This macro can be used to count how many files exist in a folder and, if passed the file extension, can also be used to count only files of a specific type. (For example "xls" files.) I've actually published two articles along this vein at VBA Expresss, but this one uses the File System Object (some know it as the File Scripting Object, or just FSO,) to do it. The biggest reason for the re-write is that I needed to use this in an Excel 2007 instance, which does not support the FileSearch method.
    If you are looking for a version to count the files in a folder AND subfolders, then look here.
    ...
    Read More Read More 2 Comments

    Function To Check If File Or Directory (Folder) Exists 

    by
    Ken Puls
    • View Profile
    • View Forum Posts
    • View Blog Entries
    • Visit Homepage
    • View Articles
    Published on 2006-09-24 11:10 PM     Number of Views: 291571 

    Introduction:
    When creating routines, it is commonly helpful to check if a file or directory (folder) exists before attempting to perform some action. Searching the internet will yield several examples of doing either, but this is a routine that I wrote in order to have one routine to test either. ...
    Read More Read More 8 Comments

    Deploying Add-ins in a Network Environment 

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

    Introduction
    The purpose of this article is to provide corporate developers with a method to release, maintain and update an add-in in a network environment. This is based upon my strategies for doing this same. ...
    Read More Read More 12 Comments

    User Defined Function To Show Formulas In A Cell 

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

    Macro Purpose:
    • Function to show the formula in another cell as text.
    ...
    Read More Read More

    User Defined Function To Sum And Round To Two Decimal Places 

    by
    Ken Puls
    • View Profile
    • View Forum Posts
    • View Blog Entries
    • Visit Homepage
    • View Articles
    Published on 2006-01-10 10:20 AM     Number of Views: 31555 

    Macro Purpose:
    • To round a Sum formula to two decimal places
    ...
    Read More Read More

    Function to Return Various Environment Names 

    by
    Ken Puls
    • View Profile
    • View Forum Posts
    • View Blog Entries
    • Visit Homepage
    • View Articles
    Published on 2005-01-04 09:32 AM     Number of Views: 14047 

    Function Purpose:
    This function can be used to retrieve one of three types of usernames, and can be used in a worksheet cell or in VBA.

    The usernames that it can return are:
    • Microsoft Office username (default) as defined in Tools|Options|General
    • Microsoft Windows logon name
    • Computer name (as defined in your system properties)

    ...
    Read More Read More 1 Comment
  • MVP Logo
  • Recent Forum Posts

    Ron Coderre

    If Nesting Question

    Try something like this:
    [CODE]=IF(H16...

    Ron Coderre Today, 02:29 AM Go to last post
    Candie

    If Nesting Question

    This is the formula I tried to use:
    =IF(AND(E161,"Good Job","Poor Quality"),IF(E16>C16,"Too Much Time","Poor...

    Candie Today, 01:54 AM Go to last post
    Candie

    If Nesting Question

    Use the IF function to complete the "Comments" column of table 1. Display "Good Job" if both the "Hours Worked" are less...

    Candie Today, 01:21 AM Go to last post
    Chi

    Formula to count the number of times a number appears in a row within in a text cell

    Hi

    I've attached a sample data, on the 'Data' tab, which shows in each cell a person's name, in short form or code, and a number, in bold...

    Chi Yesterday, 11:47 PM Go to last post
    Pecoflyer

    Specify which slicers are reset

    Hi and welcome
    Please,do not crosspost your question on multiple forums without including links here to the other threads on other forums. ...

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