+ Reply to Thread
Results 1 to 1 of 1

Searching for programming functionality help (Microsoft Excel articles and knowledgebase)

  1. #1
    Banned User!
    Join Date
    02-06-2020
    Location
    Iowa City, IA, USA
    MS-Off Ver
    2016 - 365 / 2007
    Posts
    2,014

    Searching for programming functionality help (Microsoft Excel articles and knowledgebase)

    I've posted links to these pages so many times, it's about time that the people of this community understand how it works. It's very simple. If you need to search for anything, literally, related to Excel, whether it be functions or VBA code, you can find it all on Microsoft's 2 support websites:

    support.microsoft.com and docs.microsoft.com

    Here is how you look for articles written by Microsoft on everything regarding Excel:

    Functions and Formulas
    An example of a google search that brings these listings up at the top is:
    Please Login or Register  to view this content.
    so, say for function countif(), it would be this:
    http://www.google.com/search?q=ms+ex...untif+function

    as you can see, it brings up this page:
    https://support.microsoft.com/en-us/...4-1f464816df34

    most microsoft articles have encrypted hash strings on the end of their URLs.

    VBA Coding Functionality
    An example of a google search that brings these listings up at the top is: http://www.google.com/search?q=ms+ex..._to_know_about

    so, say for the string function called instr(), it would be this:
    http://www.google.com/search?q=www.g...xcel+vba+instr

    as you can see, it brings up this page:
    https://docs.microsoft.com/en-us/off...instr-function

    the wonderful thing about the people who created the VBA documentation website is that the article pages do not have hash strings at the end of them. Either that, or they are using very clever code to un-encrypt hash strings, which I seriously doubt. That would be a pretty big waste of time and effort. So, you don't have to google search for everything all the time. you can literally paste this addressing string into the address bar of the browser you are using and get to the article you want to look at immediately:
    Please Login or Register  to view this content.
    here are some examples of VBA function articles to prove that this claim works:

    UCASE()
    https://docs.microsoft.com/en-us/off...ucase-function

    ARRAY()
    https://docs.microsoft.com/en-us/off...array-function

    RND()
    https://docs.microsoft.com/en-us/off...p/rnd-function

    MID()
    https://docs.microsoft.com/en-us/off...p/mid-function

    BUT....apparently this doesn't work all the time, as some coding features and functions are grouped together if they possess the same functional or categorical qualities in terms of what purpose they serve. such as being in the category of mathematics like fix() and int(). In their case, they have the same page:

    https://docs.microsoft.com/en-us/off...-fix-functions

    If you want to look up VBA code that is specific to Excel, as in those functions and features that use objects and related information that are part of Excel's object model and not universal to the VBA language itself, you would use this addressing protocol:
    Please Login or Register  to view this content.
    here are some examples of working web addresses:

    WORKBOOK OBJECT
    https://docs.microsoft.com/en-us/off...excel.workbook

    WORKSHEET OBJECT
    https://docs.microsoft.com/en-us/off...xcel.worksheet

    SHAPES OBJECT / COLLECTION
    https://docs.microsoft.com/en-us/off...i/excel.shapes

    CHARTS OBJECT / COLLECTION
    https://docs.microsoft.com/en-us/off...i/excel.charts

    and here are some examples of how to look up properties and methods associated with Excel objects (you can probably figure out the addressing protocol pattern of this one by now):

    WORKBOOK.SAVEAS() METHOD
    https://docs.microsoft.com/en-us/off...orkbook.saveas

    WORKSHEET.COPY() METHOD
    https://docs.microsoft.com/en-us/off...worksheet.copy

    RANGE.PASTESPECIAL() METHOD
    https://docs.microsoft.com/en-us/off...e.pastespecial

    WORKSHEET.EXPORTASFIXEDFORMAT() METHOD
    https://docs.microsoft.com/en-us/off...tasfixedformat

    RANGE.ADDRESSLOCAL PROPERTY
    https://docs.microsoft.com/en-us/off...e.addresslocal

    WORKSHEET.VISIBLE PROPERTY
    https://docs.microsoft.com/en-us/off...ksheet.visible

    FONT.BOLD PROPERTY
    https://docs.microsoft.com/en-us/off...xcel.font.bold


    Hopefully this gives some insight to others that come here for resourceful information. It can be a good first step, as these articles have been sitting on Microsoft's server network for decades now, waiting for folks to look at them.
    Last edited by vba_php; 12-18-2020 at 06:36 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Userform design from Microsoft Office Excel 2003 Programming Inside Out not working
    By Stratfordoaks in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 12-11-2013, 01:55 PM
  2. Text extraction from News Articles Into Excel
    By mmtoure in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-04-2013, 07:58 AM
  3. Microsoft Excel 2010 Doesn't Support Microsoft Excel 2007
    By Orange.CL in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 07-01-2010, 03:21 AM
  4. Searching for ADD-IN's to enhance the functionality..
    By e4excel in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-09-2009, 04:35 AM
  5. [SOLVED] How can I sort text (in excel) while ignoring articles (e.g., the
    By happy1 in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 03-03-2006, 11:55 PM
  6. check for non-blank cells in Microsoft Excel VBA Programming
    By rhodyman10@yahoo.com in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-22-2006, 09:55 AM
  7. Replies: 2
    Last Post: 12-02-2005, 12:25 AM
  8. [SOLVED] Microsoft Excel Viewer 2003 won't open Microsoft Excel Worksheet
    By Graham Jones in forum Excel General
    Replies: 1
    Last Post: 05-12-2005, 08:06 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1