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)
  • Access - SQL

    Creating an Access Database (on the fly) Using VBA and SQL 

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

    I recently had reason to create a database on the fly if one did not exist. Since it took me some trial, error and searching (and then more trial and error,) I decided to share the method to do this. The following routine will create an Access database from any VBA enabled application, such as Word, Excel, Outlook, etc...
    ...
    Read More Read More 1 Comment

    Retrieve Data From A Database To Excel Using SQL 

    by
    Ken Puls
    • View Profile
    • View Forum Posts
    • View Blog Entries
    • Visit Homepage
    • View Articles
    Published on 2006-04-12 06:52 AM     Number of Views: 71719 

    This article shows how to retrieve a recordset from a database and place it in an Excel worksheet, using an ADO connection to pass SQL strings. ...
    Read More Read More 1 Comment

    Populate Multi-Column Listbox With Data From Access 

    by
    Ken Puls
    • View Profile
    • View Forum Posts
    • View Blog Entries
    • Visit Homepage
    • View Articles
    Published on 2006-02-16 09:11 AM     Number of Views: 22833 

    Macro Purpose:
    • Retrieves data from an Access database, and fills it into a userform listbox.
    ...
    Read More Read More

    Export A Range Of Excel Data To A Database 

    by
    Ken Puls
    • View Profile
    • View Forum Posts
    • View Blog Entries
    • Visit Homepage
    • View Articles
    Published on 2004-12-21 08:09 AM     Number of Views: 45009 

    Macro Purpose:
    • Exports a table of data from Excel into a database, using an ADO connection to pass SQL strings.

    ...
    Read More Read More 6 Comments
  • MVP Logo
  • Recent Forum Posts

    alex20850

    Is there way to report or manage the number of .Add lines in a Scripting.Dictionary?

    In this function, I was able to have 3,000 .Add lines, but I don't know
    how to determine the limit beforehand or if there is a way to increase...

    alex20850 Today, 03:05 AM Go to last post
    NoS

    Copy & Paste based on multiple criteria

    for the dates, just use like this without the formatting stuff.
    Criteria1:=">=" & OKSheet.Range("C2"), Operator:=xlAnd,...

    NoS Today, 12:32 AM Go to last post
    Hercules1946

    First day of each week in a year excluding holidays

    Let me see if I understand...
    If we are talking 2018, then the first working day is Tuesday, 2nd January (assuming that New Years Day is a holiday)....

    Hercules1946 Yesterday, 10:43 PM Go to last post
    mossdrive

    First day of each week in a year excluding holidays

    I am looking for some help on creating a formula that will return the first day of each week in a quarter based on the current year and eliminating holidays....

    mossdrive Yesterday, 09:06 PM Go to last post
    Rahul Malhotra

    Copy & Paste based on multiple criteria

    Hi I am trying to copy and paste the value in the Analysis tab based on Analysis tab multiple criteria at Cell C2, D2, C3, D3, C4, D4, C5 & D5. I...

    Rahul Malhotra Yesterday, 05:42 PM Go to last post
  • Contact Us
  • Excelguru Forums
  • Archive
  • Top
All times are GMT +1. The time now is 07:32 AM.
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