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
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
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
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
I have Excel VBA code that imports Outlook mail data from one folder into Excel. I change this for three folders all at the same level (not subfolders). Is ther
I am trying to use an if else statement to delete the entire row when a text value is found in a cell within a given range. The code stops after deleting one ro