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 …

Copy values-formatting from a range to another (Excel)

In Excel, copy values and formatting only can do as follows: Select the range you want to copy. Click Edit Read More …

Negative Number as Positive (Microsoft Excel)

With a simple custom format code, we can display negative numbers as positive…but…why would we want to? So that we Read More …

How to control Macro Settings using registry keys or GPOs

For Office applications (Excel/Word,..), there are group policies that control the Macro Settings that can be checked in File (Backstage)->Options->Trust 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 …