Category "vba"

Edit 14 day weather forecast Excel VBA to include precipitation

I found the code below which works nicely and I think I can repurpose it for my needs, but does not include the precipitation. I'm relatively new to HTML so hav

Store name of email attachment - gives error on first run but works on second run

I'm attempting to open a dot .eml file stored locally and access the attachments file name with a excel macro. I've gathered some code that does the job but not

Sending mail with specific range in body using Excel VBA

I have VBA code by which I send mails with specific string body. I need this code to paste specific range(B2:F13) from sheet "MAIN" to mail body with its format

Change the background color of a whole table line based on a drop down list selection - conditional formatting

In my table (Range("A3:K9999")) there's one column E (E3:E9999), which contains drop down lists. My goal is to have the bg color changed in the whole table line

Setting Metadata in Word and Retrieving in Excel

I'm trying to write a program that updates a Word document's metadata with content control boxes. The Excel document then loops through a directory that holds t

How to find out the current group level of a range in excel for web using office-script

I am trying to find out how to identify the current group level of a range in office-script. Based on the documentation I was only able to find the group or ung

Is there a way to check if a PowerPoint is being presented using VBA code?

I am working on a VBA Module for an interactive PowerPoint. Specifically, I would like a text box to display the current time and update every second (like a li

Selenium on VBA can't find Xpath

I'm trying to find the Xpath for this HTMLcode: (Copied XPATH) /html/body/hub-menu//section-header//hubmenu-wrapper/div/search-customers//input [Picture af the

Error saving attachments when they are embedded

I'm saving Outlook attachments (as part of a copy). I get an error message from the line objAtt.SaveAsFile strFile when the attachment is an embedded image. T

How to round oMail.ReceivedTime to nearest minute?

I've a VBA macro that will save an email with the file name "yymmdd.hhmm.[Sender].[Recipient].[Subject Line].txt" that works almost the way I want. The issue is

VBA Run two Commands at once together Beep Command

I have made a program that generates frequencies using the Beep statement. For example: Beep(Val(FreqTestTxt.Text), Val(DurLbl.Text) * 1000) What I need to do t

Get text from alert message from web with Selenium and VBA

I am currently creating an automation to fill-in field in the browser (Chrome) with VBA and selenium. Which is currently doing fine. (the site is internal) How

Why doesn't changing the data point value(s) updates the value in backend excel of a ppt chart?

I stumbled onto something very interesting. So I have two charts. They have the same series names but different data. Using the below code, I replaced all the v

VBA: how can I get a list of the SMTP email addresses for the current outlook user?

I know how to get the primary email address of the current user, but how can I get a full list of all their SMTP email addresses? I'm looking for the informati

Using a collection to check if Names exist

I am trying to create a subroutine that will take a collection of a bunch of strings, step through it, and check for the existence of a named range or formula t

Loop through filtered criteria only once

The goal of this script is to loop through each criteria filtered in Column C, starting from C8 where my header is located. The information below will be a list

vba how do not count rows (or count only once) if they have the same parameter

I need to count rows in column "rating_status2" with value "unclear" and if they have the same "customer_nbr" only once. How it can be done? The structure of th

is there a way to add a word to a specific column?

The code I'm currently using only allows me to filter then replace certain values. Is there a way for me to filter for lets say column M filter for 0 and replac

Add a hidden tag to outgoing mail

I create a mail by VBA when sending invoices and automated newsletters by Outlook (2019). For reimporting the mails from the Sent folder into the database it wo

Get location of the workbook calling the script

I am trying to execute the following Python script from Excel using Sub MacrosTrigger() RunPython ("import MacrosTrigger") End Sub MacrosTrigger.py conta