I have this code and i find myself creating 12 times and modules since I have 12 different colleges, each with a unique names. I would like to make a bit more d
I have an XML file I'm trying to import into Access. I need help formatting the XSL transform to match the data. Right now, the XML imports as 3 separate tables
I'm trying to run a basic code I've found numerous places on here and elsewhere which should open SAP, input a command, and execute. I've gone as far as SAP ope
Hi all i hope you can help me with this issue since i just started learning VBA :) I need to autofilter a column of an excel sheet with the values coming from a
So I have been trying to figure out what I am doing wrong for the past two days and I can't seem to get past this error. The error is "Unable to set the Current
I am using the code below Private Sub Worksheet_Activate() MainSh.Range("D2").Select With Selection.Validation .Delete .Add Type:=xlValidateList, AlertStyle:=xl
I am new to VBA. I want to search a Word document for all occurrences of the string "the", and select all the occurrences at once. Currently, I have this code,
I am looking for VBA code in excel to reply to a selected mail but the below code creates seperate mail which does not have previous messages in conversation (t
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