Excel

Please check back soon, for further updates to this page.

1) What is an API

2) Extracting API Functions from DLLs

3) Get Dll Version & File description

Also

Here..........................................

4) Timer API

5) Change Namebox width

6) Change File Date/Time

7) What's up - Classes & things

8) Using the Comdlg32.Dll

9) Disable Printing Dialog

10) Time zones (As a prelude to this have a look here)

11) Core DLLS - STARTING WITH Shell32.dll

Using the ShellExecuteA API

Shell32.Dll - Browse for Folder

Example1 - Using Shell32 (Not API Usage) to get Dir/File details

Example2 - Get the File Info Tip

12) Get Window handle & ClassNames

13) Stop watch using winmm

14) InputBox password character via APIs

15) Addressof operation (Example via digital Clock)

16) Keeping a Window ON TOP

17) Icons on Userforms

18) Check if a File on a network is Already Open AND by Who

19) Custom message box

20) Userforms: (Note ALL of these include placing Icons on them)

Changing shapes

Splash screens

Minimize to Taskbar

Minimize to System Tray

Search Userform (Search the WWW from within XL)

Animated icon on Userform (Takbar & System Tray) NEW! Aug 2007

Icons on userforms

21) Progress Bar (In statusbar area) using comctrl32.dll

22) Play AVI in Userform using the comctrl32.dll

23) Get an executable programs file path location.

24) Tools I use (A list of some of the Tools I have developed)

Hex File Reader (From within Excel)

25) Show Windows Find / Search Dialog

26) Create Userform menus via this Userform menu creator

27) XP Style controls - Progressbar

28) Userform - display Desktop This userform displays your underlying desktop image. Move it around to display it.

29) Get Keyboard name A function to get your REAL local Keyboard name

30) Save as EMF Here is a method to save a selection, either a range OR and object eg Picture / Graph etc as an EMF File that you can then Import into another application or Userform Picture.

31) Change XP Start button text A question that caught my eye. How do you change the Start button text. I had done this before BUT the 2nd part was of interest..... changing the text to any character length AND adjusting the taskbars dimensions to fit!

32) Open / Close CD Door

33) Get screen size and ask user if he wants to change it.

34) Download Videos from YouTube using Excel, saw a video that I wanted, couldn't do it via YouTube, so here is the result.

35) Magnifier - Here is a userform that displays the image under your cursor, magnified x 2

35)