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.
  • 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: 14761 

    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

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

    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

    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 08:11 AM     Number of Views: 6735 

    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 07:09 AM     Number of Views: 14140 

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

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

    Herbds7

    bar charts with two axes

    Excel 2010, Table, PivotTable, PivotChart
    Bar chart with 2 non-overlapping series.
    http://58918aa17d4002474361-7ac2b7ee...05_21_13b.xlsx...

    Herbds7 Today, 12:22 AM Go to last post
    Herbds7

    Help with charting. How to use only last 15 rows after updating.

    Excel 2010 Table, Chart
    Use Defined Names
    Tables are dynamic.
    http://58918aa17d4002474361-7ac2b7ee.../05_21_13.xlsx...

    Herbds7 Yesterday, 08:25 PM Go to last post
    Hercules1946

    IF AND Statement with ISBLANK and conditional

    Great - Im glad you resolved it.

    Herc...

    Hercules1946 Yesterday, 05:42 PM Go to last post
    cane

    Unsure how to change vba code to work properly select case and me.controls

    I have this code: It works as displayed in the first table.
    Set wbk = Workbooks("News.xlsm")
    For i = 2 To 11
    Select Case Me.Controls("Combobox"
    ...

    cane Yesterday, 05:40 PM Go to last post
    emartz

    got it!

    Hi--got it, I inserted an IF statement in the vlookup that pulls the container # from the other tab that way it returns a blank cell if there is no value...

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