I have multiple Excel workbooks some having multiple worksheets. I'm trying to export the duplicates across the workbooks into a new workbook using Column A of
I want to create issues in Jira based on Outlook emails received using VBA. However, when setting the assignee/reporter via the REST API it appears that users c
I have a document saved on SharePoint that documents testing. Once testing has been completed I would like to move the tests (entire row) to a separate sheet to
I'm trying to delete all duplicate rows based on Column B and leave only the unique rows. It will leave one of the duplicate entries. I tried with > 1 and =
I refer to this: How to have VBA code wait until vbModeless userform is closed I tried to apply the code in a class module for my problem. Problem description:
I have this data This code grabs column "BO" and copies it to the right. I need a repeatable macro that copies column BK and inserts it to the right, which push
I am trying to put together the 'Hello, World' of a macro button that will make an option/radio button on a cell in an Excel spreadsheet, the simplest possible
I want to extract a word from text which is separated by commas. This is one of the data from users. 117573,117573,219,219,75,75,Messi,barcelona,53780217,forwa
Here is my code I've set up and is working as a vlookup. (I can follow this and I will understand it when I come back to it in 2 years.) Sub lookup() On Error
I'm trying to get all tables from sql database. This is simple code Public Sub TestAction() Dim i As Long Dim objRec As New ADODB.Recordset Dim objConn As New A
I'm a beginner with APIs. I'm trying to upload a file to imgBB using an API. But I get the error message: "{"status_code":400,"error":{"message":"Empty upload s
I am try to convert MS Access Report "Premier Practice" to PDF file "Premier Practice.pdf" than convert to Premier Practice.doc. Finally open Premier Practice.d
I have some existing VBA code that works great for exporting all tabs in my workbook as individual sheets named by the tab name. I just want to be able to set
Pivot table data source Please see the above image. I am trying to dynamically update the pivot table data source whenever a new sheet is created. Essentially I
So I have the following code that works correctly and uses a column with URLs to add the images to the next column. The problem being that if you send it to so
So, I have a bunch of old .xls files that I want to convert to .xlsx files for the sake of disk space economy. Doing it one-by-one is out of the question. I see
I need to change the lookup_value of RC[-2] with the address Cells(3,2) on the macro code below. Range("D4").FormulaR1C1 = "=VLOOKUP(RC[-2],'[Reference Workbook
the following code causes runtime error '1004' Method OnKey of object '_Application' failed! Any suggestions? Sub MyAchieve() Dim col As Integer Dim row As
I need some VBA code in outlook to save specific lines of data from emails as per below into an excel folder - see sample excel table below. I need the code to
I'm trying to import many tables into excel (with fixed width option selected) and I would like it to paste it to certain areas as a function of "i", see below: