+ Reply to Thread
Results 1 to 7 of 7

Excel 2013 VBA Developer Documentation & Offline Help

  1. #1
    Valued Forum Contributor
    Join Date
    12-02-2012
    Location
    Melbourne, VIC
    MS-Off Ver
    Excel 2016
    Posts
    750

    Excel 2013 VBA Developer Documentation & Offline Help

    I have the Excel 2013 Developer Documentation CHM file that I can search through for help re any object/property/method, but it is far more convenient to press F1 from the VBA IDE when one needs some help re any of these. Currently, when one does that, Excel 2013 directs to the MSDN website (which is fine when one is online, but that isn't always the case, and the internet speeds aren't great all the time either).

    Is there a way to install/get VBA help offline in Excel 2013? So one can use the context related help (using F1 key).

  2. #2
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,636

    Re: Excel 2013 VBA Developer Documentation & Offline Help

    Not sure this option exists in excel 2010 but on the bottom right hand corner of the help menu you can change the connection status to offline

    also found this
    https://www.microsoft.com/en-us/down....aspx?id=40326


    **yes it does exist in 2013
    picture/blog is for word but works for excel as well
    http://wordribbon.tips.net/T009352_G...p_Offline.html
    Last edited by humdingaling; 01-27-2016 at 01:01 AM.
    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

  3. #3
    Valued Forum Contributor
    Join Date
    12-02-2012
    Location
    Melbourne, VIC
    MS-Off Ver
    Excel 2016
    Posts
    750

    Re: Excel 2013 VBA Developer Documentation & Offline Help

    That's not the same as what I was looking for. This applies to Excel Application help, and yes there is a way to use local offline help instead of the default online one (albeit slightly differently than suggested in the link).

    I'm looking for the VBA help aka Developer Help Documentation. In Excel 2010, it is available offline. Not only that, when you press the F1 key whilst your cursor is on any keyword (object/method/property/function) in the VBA IDE, then the Help window goes straight to that particular topic (this as I read is called 'context related help'). However, in Excel 2013, it still works, but defaults to the Online documentation instead. This is very inconvenient as:
    • one is not always online.
    • the internet speed isn't great all the time. In any case, it will always load much slower than the local help file.
    One can download the CHM help file, and search through it manually, but it is not context related.

  4. #4
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,636

    Re: Excel 2013 VBA Developer Documentation & Offline Help

    noticed the link above doesnt work today
    try this instead

    https://www.microsoft.com/en-au/down....aspx?id=40326

    **oh this it that CHM thing you mentioned already

    shrugs dont have 2013 ..cannot replicate
    sorry

  5. #5
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,636

    Re: Excel 2013 VBA Developer Documentation & Offline Help

    Further investigate seems to point to the fact that context sensitive help is not available offline for 2013

    they seem to expect you to either work without context using the offline as emergency or work online

  6. #6
    Valued Forum Contributor
    Join Date
    12-02-2012
    Location
    Melbourne, VIC
    MS-Off Ver
    Excel 2016
    Posts
    750

    Re: Excel 2013 VBA Developer Documentation & Offline Help

    what a pity! having local contextual help is so handy. I use it all the time.

  7. #7
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,636

    Re: Excel 2013 VBA Developer Documentation & Offline Help

    i usually just google stuff or use my stash of example files
    never knew it existed until i read this post
    might start trying it since i'm still on the 2010

    another reason not to upgrade

+ 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. Set Outlook 2013 to work offline
    By ibreno in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-18-2015, 12:40 PM
  2. how to activate Developer Tab in Excel 2013
    By roofi in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-21-2014, 03:19 AM
  3. Excel 2013 Home and Student developer tab won't run or read macros
    By cliffdprice in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-15-2014, 09:44 PM
  4. Replies: 1
    Last Post: 02-22-2008, 05:35 PM
  5. excel 2003 and c++ API documentation?
    By danAutodesk in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 07-26-2006, 09:35 AM
  6. [SOLVED] Excel Format Documentation
    By CNKS in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-26-2006, 11:10 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