Category "vba"

Find duplicate column values across multiple workbooks, and extract columns row data to new sheet

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

How to query a user name by a email address in Jira Rest API

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

Is it possible to copy, paste, and delete data from one sheet to another in office scripts?

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

Deleting duplicate values

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 =

Using userform vbmodeless in a loop

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:

How to copy the last data column and insert it immediately to the right?

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

How to add option button to spreadsheet?

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

How to return a word from between nth comma and n+1 th comma?

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

Find xlprevious code bringing up first record not last

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

Getting adSchemaTables from sql database

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

Trying to upload a picture via an API but get "Empty upload source" error

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

Error on VBA during conversion from PDF to Doc file in MS Access

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

Export Excel tabs and set page formatting at same time

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 automatically update

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

Excel add image to workbook from URL using shapes.AddPicture VBA Macro

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

Converting .xls to .xlsx files with VBA doesn't seem to reduce size

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

Is there a way to change the lookup_value of the Macro code with the identified cell address?

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

Runtime error 1004 Method OnKey of object '_Application' failed

the following code causes runtime error '1004' Method OnKey of object '_Application' failed! Any suggestions? Sub MyAchieve() Dim col As Integer Dim row As

VBA in Outlook to pull specific data into excel

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

Process to Import specific text in excel with VBA

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: