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.

  2. Unregistered, Nice to see you again, please help us to help you by clicking this link Edit My Profile and add your current version of Excel.

    There's a quick explanation here How-to-show-us-what-Excel-version-you-are-using

    Kind regards,
    Admin
  • Knowledge Base Articles By Category

    Access - ADO (4)
    Access - SQL (4)
    Access - VBA Programming (10)
    Downloads - Games (1)
    Downloads - Learning Aids (11)
    Downloads - Utilities (7)
    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 (2)
    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 (2)
    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 08:15 AM     Number of Views: 22453 

    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: 50785 

    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 10:10 PM     Number of Views: 283696 

    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 09:27 PM     Number of Views: 54118 

    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 10 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: 14709 

    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: 30822 

    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: 13335 

    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

    Sahil1390

    Copy & Paste based on multiple criteria

    This query needs to be in VBA category. This is formula category....

    Sahil1390 Today, 12:58 PM Go to last post
    Sahil1390

    Row changes

    This can be done using countif, vlookup functions etc....

    Sahil1390 Today, 12:56 PM Go to last post
    Sahil1390

    HOPE!! Its Works...

    Please find the file attached with and do verify the solution....

    Sahil1390 Today, 12:53 PM Go to last post
    Bill Szysz

    how to merge rows after pivot and group by...

    Check this file.... is that what you want?...

    Bill Szysz Today, 10:55 AM Go to last post
    Andy D

    Row changes

    Hi allI need some help with working out changes in row data from one spreadsheet to another
    I have two spreadsheets Green Prop New and Green Prop...

    Andy D Today, 08:41 AM Go to last post
  • Contact Us
  • Excelguru Forums
  • Archive
  • Top
All times are GMT +1. The time now is 01:48 PM.
Powered by vBulletin® Version 4.2.5
Copyright © 2018 vBulletin Solutions Inc. All rights reserved.
Thread / Post Bookmarking by Thread / Post Bookmarking v1.1.0 - vBulletin Mods & Addons Copyright © 2018 DragonByte Technologies Ltd. Runs best on HiVelocity Hosting.
Copyright © 2004-current by Excelguru Consulting Inc.
Gravatar by 1e2.it