After yesterday’s post on how we can extract the MIME type from an HTML Img src attributes:

I thought that I’d show how we can slightly adapt the code to be universal.  Instead of creating one off functions for each and every scenario, how we can build a single function that we can use for all cases.
 
Continue reading →

In a continuation on the subject of Early and Late Binding:

I decided I should provide a few examples of going from Early to Late binding and vice versa and give the necessary VBA Reference Library for Early Binding …

These should be great starting points in knowing which Reference Libraries are required for which Early Binding declarations, and also aid anyone wanting to convert in either direction.

I hope this help a few of you!

These are the Examples provided thus far:

 
Continue reading →

I was working on some HTML automation recently and needed to extract the MIME type from an HTML Img Src Attribute value.

I could get into Left, Right, Mid, InStr, Len, …, but I thought I’d stretch my VBA RegEx legs a little and create a simple reusable function to do the job.

In case it can help anyone else out there, here it is!

Continue reading →

I think one of the most underutilized methods for developers is the Print method! Beyond which, those that do use it often don’t necessarily use it to its full potential.

What Is The Print Method?

The print method allow us to output (or ‘print’) information/values/content to VBA/VBE the Immediate Window.
 

How Is That Useful?

I know developers that don’t see the utility of Print when they have MsgBox, but they serve 2 distinct purposes.

MsgBox is more for the end-user, to display a message to them. Sadly, you can interact with a MsgBox. Amongst other things, you can’t copy the contents.

Print is only for the developer as it is displayed in the VBE Immediate Window.  The beauty here is:

• that you can copy/paste its content which is great to search up those error numbers/descriptions.
• use it while in the VBE creating code without having to switch back and forth to the Access GUI and VBE windows
• using the options, and other techniques, you can format the output.
• you can sprinkle it throughout procedure to see the evolution of variables, … in real-time. This is great for debugging purposes.

 
Continue reading →

In this article, I decided to play around with Windows SIDs and inversely the associated username.

It can be required, say when trying to look certain information up in the registry, to determine the SID of a Windows account. Or perhaps, inversely you have an SID and you’d like to know the Account Name it is associated with.
 
Continue reading →

Last week I published a few functions to retrieve things like you Local IP & your Public IP address, you can learn all about it by reading:

Today, I thought I’d show you how easy it is to access another important Adapter property, the MAC Address(es).

All the examples I’ve seen always return a single value, but this can be incorrect depending on your setup! This is why I provide examples that return all the MAC addresses from your PC!
 
Continue reading →