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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
I am trying to execute the following Python script from Excel using Sub MacrosTrigger() RunPython ("import MacrosTrigger") End Sub MacrosTrigger.py conta
We have an Excel 2016 quoting tool that uses VBA code to compare the product codes entered against an Access database and then update another sheet with the det
I need to encrypt SSN (nvarchar(25)) field in a SQL Server database table. Once encrypted, the Access program needs to be able to decrypt the field for user vi
I was just wondering: It is possible to create a click button in VBA Excel that opens the VBA editor when the button is clicked? UPDATE: The p