So I had to create a couple of drop-down lists in Microsoft access and all of them are supposed to have different font colors. I did write the code for a single
I am trying to skip cells that have prefilled data. If I were to select a day of the week in my schedule certain people would have the day off. I am trying to s
I have Excel VBA code to delete strikethrough text: Private Sub DelStrikethroughText() 'Deletes strikethrough text in all selected cells Dim Cell
I want to create an Outlook Meeting, which references on a Microsoft Teams Team-Channel Meeting. I am searching for a way to change the link behind the Button y
I have a macro that splits a string (list of names) using a space as the delimiter and creates a new row for each name while keeping all data the same in other
Our office runs Arobat DC Pro and Excel 2016, we have been using the code below (scaled down version) in Excel VBA for years to save active Adobe PDF documents
I have code that reads mail to generate a task with the mail's content. In a few cases this hits a problem, when reading the RTFbody from the mail, saying "not
Is there a way to identify if a worksheet has a highlighted cell at a worksheet level, without checking all the cells? Further context: I have a WorkBook with a
I have an Excel file for label template with 6,300 items (each item has a parent ID which matches the picture name that suits the child item). I found code that
I have a MS Access database that has a switchboard on it that opens different forms within the database. For some reason, some of the users like to double click
I currently have code that inserts two columns, and copies values from two other columns into these two new columns. 'Insert 2 Column to the Left of S Colum
I have an existent graph to which I added a macros. The macros should update the axes, add a datalabel to the last point and delete the datalabel of the previou
How can I access the methods of Office.SensitivityLabel in Outlook 365 that will allow me to create and set a label for a new email. Looking at the (sparse) doc
I'm trying to get the shorten bit.y URL in my excel file, but instead I'm obtainig the following message, {"created_at":"2022-05-04T21:48:32+0000","id":"bitly.i
could someone help me to create script for moving emails in the outlooks folders based on value added to inputbox? Idea is that, I select one or more emails and
From our audit database I derive an Excel table like this one below. What I need to do is populate a table in a word template document with the content of the f
There's a website that provides weather data: https://www.visualcrossing.com/weather/weather-data-services I want to import that data into a table with a butto
I'm trying to fill a Word document with plain text files in VBA. Here is what I have : The Word document has bookmarks with default text inside (this helps me t
Part 1: Please help to advise where did it went wrong. Would like to sort for column E via descending order with header Sub SortRows() Dim destSht As Worksheet
Hi I am having 11 sheets in my workbook. I need to delete some contents in all the sheets except 1 sheet. I have written some code. while I am rund the code act