The code works when the criteria exists. I get an error when the criteria doesn't exist. ' Define constants. Const srcName As String = "wfm_rawdata" Const srcFi
By default, my MS Outlook 2013 is set NOT to download images in received HTML e-mail messages. I would like to keep this setting. There are some senders whose
I'm referring Parent class from Child class; instead of simply do, for example: Public Property Set Parent(obj As ClassProperties) Set this.ParentColl = ob
I am trying to extract the email address from each individual undeliverables email body. The email body would be like: ----------------------------Email-------
I would like to use Microsoft ScriptControl to parse a JSON string in VBA, and then transform the resulting Object into Dictionary and Collection objects. I alr
I am creating a Word document which contains macros that will convert the .doc to .PDF, and include it as an attachment in an autogenerated Outlook email contai
I know the method as Application.Visible = False and Application.Screenupdating = False When opening the file, I want the user to see only the userform. The
I'd like to move the selected email to the "Junk Email" folder and create a spam rule for that email address that automatically sends all future emails from tha
I have an Excel document consisting of data imported into multiple tabs. The columns in each tab are stretched out and hard to read. I am trying to cycle throug
The code is intended to add the same hyperlink to all Heading 1 style text. (Purpose: clicking any heading brings you to the top of the document). It works for
I need to get multiline text from textarea element of web-page. I see in Chrome developer tool that text I need is stored in value property of textarea. I marke
With the help of the web, I have been able to write some VBA to check content controls on a Word 2013 template document and use the content to create a filename
I have a workbook with several comboboxes (and listboxes) and a lot of vba written around them. I've used the same code in the Workbook_Open procedure to format
I would like to exit my for loop when a condition inside is met. How could I exit my for loop when the if condition has been met? I think some kind of exit at t
I'm trying to create a SHA256 object from MS Access VBA. I'm running Access 2016 on a Windows machine with .NET 4.8. Public Function Base64_HMACSHA256(ByVal sTe
I am creating an activity tracker in Excel. I'd like to be able to "Select all that apply" from drop down lists in two separate columns on the same sheet. I am
I wrote a macro to check if a date is the last day of a month. If so this cell should blink every 1 second, so I'm calling a Do While loop. I want to start the
I'm trying to use two custom lists to order the columns in a specific reach. First I define the two custom lists (arrays) and in the .Sort statement I give the
How do I color all the series (lines) in a specific (selected/current) chart the same color? I have the following, but it does nothing: Sub Same_Color() Dim
The accepted wisdom is that using a construct like Dim dict As New Dictionary is poorer in performance than Dim dict As Dictionary / Set dict = New Dictionary.