top of page
Search

Over 2,500 Windows API Functions now available to be added directly to your VBA Project

  • Writer: John
    John
  • 2 days ago
  • 2 min read

As of release 1.7.4.0, VBE_Extras is now able to add 2,538 separate Windows API Functions along with 601 Types, 99 Enums and 11,978 Consts to your VBA code (in the VBE_Extras main menu, select "Other tools" then "Add Windows API declarations").


Based on your selected options, it will:

  • Add only the VBA7 version (e.g. with "PtrSafe" and "LongPtr") or both VBA7 and pre-VBA7 with appropriate conditional compilation

  • Add the ANSI or Unicode variants of Functions and Types that have both variants

  • Automatically convert String value types to Long/Ptr value types so that, using StrPtr(), you can avoid the (ridiculous ... who ever thought it was a good idea!!) conversion between Unicode and ANSI

  • Automatically include any dependencies (e.g. if you add a Function to your code that uses a Type, it will also offer to add that Type ... same for Types that use other Types, Functions or Types that use Enums or Consts etc.)

  • Automatically include Const "groups" (i.e. if you add one Const that comes as part of a wider group of Consts, which most of them do, it will also offer to add the other Consts)


In addition to adding declarations directly to your code, VBE_Extras can add (or direct you to) example usages for 757 Windows API Functions (plus a large number of Types, Enums and Consts). The majority of examples are stored within VBE_Extras and can be added directly to your VBA Project or shown as a text file (the remaining examples are online ... VBE_Extras will open the relevant web page for you).


See the Automatically add Windows API declaration(s) post for more details.


In addition to that, when working with Windows API declarations, you often want to read the Microsoft documentation web page to understand the details of how the declaration works, what it returns, what the parameters require etc. If you press the F1 key while the cursor is on a VBA keyword then (if you're lucky) the VBE will open the relevant Microsoft web page for that keyword ... but it won't do that for Windows API declarations. VBE_Extras enhances the F1 key functionality to do that for any of 12,478 Windows API Functions, 4,122 Windows API Types, 689 Windows API Enums and 11,007 Windows API Consts.


See the Using 'F1' to view Windows API web pages post for more details.



Comments

bottom of page