Microsoft says that some VBA programs might break after installing the security updates for the CVE-2020-0760 Microsoft Office remote code execution vulnerability released as part of the April 2020 ...

Represents an equation. OMath objects are members of the OMaths collection. Dim objRange As Range Dim objEq As OMath Set objRange = Selection.Range objRange.Text = "Celsius = (5/9)(Fahrenheit - 32)" ...

Modules are just bags of code, intended to be shared between more than one worksheet or object. You can't explicitly place modules into the Objects folder; code that lives there is actually contained ...

FileArry Get: Returns the content of a text file as an array. Let: Write the content of an array to a file FileExtension Returns a the extension of file's name. The file may be provided either as file ...

I have been using an Outlook VBA macro to parse email bouncebacks. For some reason a large number came back from my last campaign as an olReport type. For some reason the Body of these messages cannot ...

Trust me: There's actually a tip at the end of this column, but it's going to take me awhile to get there. Be patient -- I do have a point and I am getting to it. When it comes to comparing objects, ...