Here you are a minimal, reproducible example with the error. I have a class CreateXSSFColor. Firstly, I define the styles estiloBasico and celdaVaciaGris. When
I want to delete all the rows containing the word "Resigned" only in column O. This is my code below to process 331,000+ rows. Is it the most effective or fast
I'm trying to use search in a description to see if there is an exact match to the field in another table. I used the code from How to search a row for a subst
I have tried numerous ways but have failed to get the right data to the new columns. The column description contains a lot of information in which I want to ext
EDIT1: download file with 2 days of real data My home automation controller collects data from several 4-in-1 motion sensors in different rooms of my house. The
I have a few spreadsheets with various tables in different formats. My task is to locate and identify anything on the spreadsheets that can be considered a tabl
I have an xlsx workbook on my desktop with existing sheets. I have a dataframe in R that I would like to add to this workbook as a new sheet. Using library(open
I'm using this code with vb.net and I'm successfully connecting to the database. However when I try the same code in Excel I'm getting error "run time error 37
I have a really large dataset with a column showing (date and time), X-coordinates the object, Y-coordinates the object, Z-coordinates the object, and speed the
I'm trying to build a second tab in my Excel Add-In and I can't get it to work. I've basically duplicated my first tab and if I delete either tab, they show, bu
I don't know a lot in Excel but I want to add Multiple prefixes in Excel and let them loop until the number of cells ends. I used this Formula, but it picks the
I am currently struggling with coding and need help from an expert. Help. There are a large number of classes ("df-table") on that link homepage. The first clas
Good morning, I have this code below that send an email with an attachement (excel file) and a table in email's body. Sub Email() Dim outapplication As Object
I'm looking to change the behaviour of Odoo 14 Export to Excel function. At the moment if I select at the same time several records of a model and run the expor
Input: Sub RangeFindWithDoubleType() Dim strResult As range With ActiveSheet.range("A2:A11") On Error Resume Next Set str
I have a script that writes data to a csv file, but if that csv file is open (in the excel application on Windows 10) then it generates a PermissionError. This
The purpose of the code below is to check whether or not a sheet already exists in excel workbook. If sheet exists, then set sheet as active sheet with given na
I am relatively new to VBA and have managed to edit a worksheet_change sub from example code found online (Thanks Tim Williams!) that allows multiple selection
I've set up a macro to send an e-mail through Outlook. .Body is read from a cell inside the file with indents. Since the value will change depending on the usag
I get 50 mails with Excel sheets per day. I want to add the first line of each Excel sheet to an existing Excel sheet located on my computer. I first wrote a sc