Private Profile Strings using Words System.PrivateProfileString using VBA in Microsoft Excel

If you don't want to use API-functions you can use Words object library to read and write Private Profile Strings. Words System.PrivateProfileStrin...

Private Profile Strings using INI-files using VBA in Microsoft Excel

Private Profile Strings are often used to store user specific information outside the application/document for later use. You could for example store...

How to Insert Pictures Using Excel VBA

Hi There! Trying to rock the dashboard with meaningful pictures. Or just trying to insert picture into cell Excel VBA. Well, you can’t insert pictur...

Convert negative values treated as text using VBA in Microsoft Excel

In this article, we will create a custom-function to convert negative strings to an integer. Raw data for this article consists of strings followed b...

Basic information about OLE automation using VBA in Microsoft Excel

When you want to use functionality from other applications you have to decide if you want to use early or late binding of object variables. Early ...

Playing WAV-files using VBA in Microsoft Excel

It's easy to play soundfiles in WAV-format. You only need to know the filename of the sound you want to play, and decide if you want the macro to wai...

Playing MIDI-files using VBA in Microsoft Excel

Soundfiles in MIDI-format are often long, so it might be necessary to stop playing the sound (e.g. when the macro is finished). Here is an example: ...

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.

Visit Us On TwitterVisit Us On FacebookVisit Us On Youtube