• Useful Links

    Reference Sites
    • Anne Troy's Office Articles
      • Anne has over 230 articles and tutorials available for the MS Office suite! Well worth the read!

    • Andy Pope's "AJP Excel Information"
      • Andy's site is very heavy on Charts, with lots of great pictures and examples. He's also got a collection of Excel based games as well.

    • Bob Phillips xlDynamic
      • Bob's site contains very comprehensive papers on Excel formulas and VBA. My personal favourite is his explanation of Multiple Condition tests using Sumproduct.

    • Chip Pearson's Excel Information
      • Chip has an incredible amount of information on his site, including using the Windows API to get at things not accessible through VBA alone.

    • Colo's Junk Room
      • Colo has all kinds of neat things at his site, including a Class Module tutorial, and tips for teaching VBA programmers how to program in javascript. (This site went offline back in 2011, but the link above accesses the most recent copy via the Wayback Machine.)

    • Deskbright
      • Sam McIntire's goal is to help people succeed at their work, and where better to start by hosting examples using a variety of functions within Excel?

    • Excel-easy.com
      • Niels Wetterings' has a great site with lots of easy examples to follow.

    • Ivan F Moala's Xcel Files
      • If it can't be done in Excel, Ivan will have an example of how it can... A site full of truly amazing information and undoubtedly bookmarked by every Excel developer. (This site went offline back in 2012, but the link above accesses the most recent copy via the Wayback Machine.)

    • Jan Karel Pieterse's JKP-Ads
      • Jan Karel Pieterse is the author of the Name Manager and a MS Excel MVP.

    • John Walkenbach's Excel Information
      • Author of the Excel VBA Power Programming series... a MUST have book for any aspiring VBA programmer!

    • Jon Peltier's Site
      • Jon's site is the first place I look if I need to know how to do something with Charts in Excel.

    • Mark Rowlinson's Code Net
      • Mark has some great articles including coverage of Visual Basic, Office and Web programming. My particular favourite is his tutorial on Passing arrays to and from functions. (This site went offline in 2013, but the link above accesses the most recent copy via the Wayback Machine.)

    • MVPs Excel sites
      • The above is the direct link to the MVPs.org Excel site listing. It lists all of the Excel MS MVPs and alumni sites

    • Ron de Bruin's Excel Pages
      • If you need to know something about sending email from Excel, this is the place to go. If you're looking for Outlook, Outlook Express or CDO, Ron has examples.

    • Rick Grantham - The small business champion

    • Russell Proctor's Better Solutions
      • Russell has a bunch of information for Word, Excel, Power Point and general programming. (This site went offline in 2014, but the link above accesses the most recent copy via the Wayback Machine.)

    • Stephen Bullen's Office Automation
      • Stephen Bullen is one of the true Guru's of Excel, and co-author of Professional Excel Development, among other things. His site has some great utilities available for download.

     

    I'm afraid that you must be logged in to comment or leave a testimonial. I wish it could be otherwise, but I'm trying to keep my site spam free for everyone's benefit. If you don't yet have an account it's completely free to sign up, and a very quick process. Simply click here to Register. Not only can you post a comment here, but it gives you full access to posts questions in our forum as well!

     

    If you already have an account, and just haven't logged in yet, what are you waiting for? Login Now!

  • MVP Logo
  • Recent Forum Posts

    Eflats1

    Auto fill web form

    Here is a copy of what the code looks like and also a screen shot




    Warranty/Guarantee...

    Eflats1 Today, 01:59 PM Go to last post
    Eflats1

    Auto fill web form

    I am close to completing the macro I need to auto fill a web form. I understand the basics of the code and how they reference the html elements but I...

    Eflats1 Today, 01:25 PM Go to last post
    alansidman

    Pivot table and date groupings

    No toe stepping here. I am at the early stages also. And as we already know, there are many ways to accomplish the same result in Excel. Glad to see...

    alansidman Yesterday, 10:32 PM Go to last post
    p45cal

    Pivot table and date groupings

    I don't mean to stand on other's toes - I'm getting to grips with Power Query etc. and wouldn't mind some feedback.
    I experimented and ended up...

    p45cal Yesterday, 08:14 PM Go to last post
    p45cal

    Hiccups in exporting data to Excel from Notepad

    …and I did it with a macro. See attached with a button which runs the code below. It adds a new sheet to the workbook.

    Code:
    Sub blah()
    Dim Headers()
    ...

    p45cal 2019-05-17, 07:26 PM Go to last post