Replace Function to replace characters in a String (VBA)

Use the VBA Replace function to replace a substring of characters in a string with a new string. VBA Replace Read More …

Outlook – Replace E-mail Addresses Display Names

Scenario I need the full email address displayed when I print a sent email so that I can prove exactly Read More …

Delete custom styles in Microsoft Excel with VBA

Often times, especially when sharing files, perhaps emailing files back and forth to/from co-workers, a file can become bloated with Read More …

FileSystemObject on VBA [XML]

Login (or register) to download directly this XML. 🙂 Click here to download this article’s XML! Source Go to source! Read More …

FileSystemObject on VBA [XPS]

Login (or register) to download directly this XPS. 🙂 Click here to download this article’s XPS! Source Go to source! Read More …

FileSystemObject on VBA [PDF]

Login (or register) to download directly this PDF. 🙂 Click here to download this article’s PDF! Source Go to source! Read More …

FileSystemObject on VBA [DOCX]

Login (or register) to download directly this Docx. 🙂 Click here to download this article’s Docx! Source Go to source! Read More …

Excel – Save your custom functions and macros in an Add-In

Macros and custom functions are great, they can automate many tedious tasks. To have them available whenever you need them, Read More …