Category "vba"

Microsoft Office 365 Outlook. How to Change Teams-Meeting Join link

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

Split string cell into multi rows but keep original row

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

PDDoc.Save Adobe Acrobat method not working in Excel VBA

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

Reading mail RTFbody fails with error 'not implemented'

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?

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

Save picture as a picture instead of link when using VBA in Excel

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

How can I cancel a button's action on an Access form if the button is double clicked?

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

How to copy a column value if condition is met in cell to the left

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

VBA doesn´t add datalabel

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

Changing SensitivityLabel in Outlook 365 email with VBA

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

Bitly API v4 - VBA Excel Macro

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

Move selected email to folder based inputbox value, Outlook

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

Populate word tables from an Excel table

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

Getting data from URL into MS Access table

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

VBA Word - InsertFile changes the style (font, size...) of the bookmark and adds a new line

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

Error 1004 keeps popping out when trying to execute the sort VBA command

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

Clear the Multiple Page content in simple coding

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

Object required for comboboxes/checkboxes that already exist on my worksheet?

Okay, totally noob coder here. I'm working on a sheet that has a repeating series of 1 combo box linked to one other combobox and a checkbox. Basically, the fir

How to reduce the displayed Majorgridlines in order to match them to the "Category" texts?

Within this picture, an Excel chart is displaying approximately 100 values + times (red curve): Excel is "intelligent enough" to reduce the number of the displ

Transferring string arrays from VBA7 to C++

I'm currently working on a project where I want to be able to manipulate and graph data with relative ease in Excel. However, a lot of the data involved exceeds