Results 1 to 8 of 8
  1. #1
    2 Star Lounger
    Join Date
    Feb 2003
    Location
    Piscataway, New Jersey, USA
    Posts
    171
    Thanks
    0
    Thanked 0 Times in 0 Posts

    API Viewer for VBA? (VB6 VBA )

    Hi gurus:

    Here's a challenge. VB has a neat addin called the API Viewer that shows you the declare statements, types and constants needed for API calls. I'd LOVE to run it from my Access development environment, but VB's addin file extension doesn't work. Anybody know how?

  2. Get our unique weekly Newsletter with tips and techniques, how to's and critical updates on Windows 7, Windows 8, Windows XP, Firefox, Internet Explorer, Google, etc. Join our 480,000 subscribers!

    Excel 2013: The Missing Manual

    + Get this BONUS — free!

    Get the most of Excel! Learn about new features, basics of creating a new spreadsheet and using the infamous Ribbon in the first chapter of Excel 2013: The Missing Manual - Subscribe and download Chapter 1 for free!

  3. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 16 Times in 16 Posts

    Re: API Viewer for VBA? (VB6 VBA )

    Why don't you just start the API viewer by itself? It is a stand-alone application. You can easily switch back and forth using Alt+Tab or the task bar. Use the Copy button in the API viewer, then paste the selected definition(s) into your Access code.

  4. #3
    3 Star Lounger
    Join Date
    Aug 2002
    Location
    Leuven, Vlaanderen, Belgium
    Posts
    312
    Thanks
    5
    Thanked 0 Times in 0 Posts

    Re: API Viewer for VBA? (VB6 VBA )

    Alan,
    just wondering... some googling revealed this page providing a help file which might be the one you use:
    http://www.helpmaster.com/hlp-develo...ds-hdg2api.htm
    Could it be...?

  5. #4
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: API Viewer for VBA? (VB6 VBA )

    There is a stand-alone and more current API viewer available from http://www.allapi.net. I personally prefer using their API-Guide, which includes descriptions and samples for using the API calls.
    Charlotte

  6. #5
    Platinum Lounger
    Join Date
    Nov 2001
    Location
    Melbourne, Victoria, Australia
    Posts
    5,016
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: API Viewer for VBA? (VB6 VBA )

    Thanks for that link. I hadn't seen that particular version, although I used to converse with its author a few years back on the sorts of issues that help file is intended to address. It's not so relevant to VBA, which is not stuck with the sorts of limitations of WinHelp or the old WordBasic:<blockquote><hr>
    The sole aim of this file is to provide a quick and dirty means of finding a corresponding RegisterRoutine declaration to common Win32 API functions. This work is derived from WIN32API.TXT, a file distributed by Microsoft for use of Win32 API calls in WordBasic. Since WordBasic has similar limitations to WinHelp (i.e. inability to use structures and types, etc.) it seemed like a good starting place...

    Copied from "The WinHelp Developer's Guide to the Win32 API",

  7. #6
    Platinum Lounger
    Join Date
    Nov 2001
    Location
    Melbourne, Victoria, Australia
    Posts
    5,016
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: API Viewer for VBA? (VB6 VBA )

    Thank you Charlotte. This is a wonderful little application and an excellent site generally... can't understand how I hadn't stumbled across it before.

    Alan

  8. #7
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: API Viewer for VBA? (VB6 VBA )

    I use it a lot, but it is no longer being updated because of the move to .Net and Windows 2003.
    Charlotte

  9. #8
    Platinum Lounger
    Join Date
    Nov 2001
    Location
    Melbourne, Victoria, Australia
    Posts
    5,016
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: API Viewer for VBA? (VB6 VBA )

    I use an incarnation that's in the form of a standalone .HLP file (don't know its source, sorry) so can't comment on the add-in you mention. But the Using the WinAPI Viewer Application Microsoft Office 2000 Developer link might be of some help.

    Alan

    Edited - The help file I use is win32s.hlp which comes with various Borland packages. Although it appears that some of these are free to download, I've not seen a downloadable version of this file in isolation. It's a 24MB job too, BTW.

Posting Permissions

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