I was using regularly a macro add-in in excel which stopped working all of a sudden. I get several error messages in the following order when I launch the macro
I'm trying to export all sheets in the workbook as separate pdf files using one button. I followed a YouTube tutorial: https://www.youtube.com/watch?v=FRZ6n3gHt
I am trying to use a vlookup / index to pull some numbers. Sample data attached: A: merged cells (the number is stored in the top of cell of the merge) B: Only
I currently have a Data Pipeline within ADF that pulls data from multiple REST APIs, transforms the data and stores it in an Azure SQL Database and from there i
I am trying to read excel file in pycharm using pandas. I installed the package successfully. My issue is that I am trying to use file location in addition to i
I have an Excel document that is constantly updating it's values every couple of seconds through a link. Is there a way I can trigger some kind of stored proced
If I have table 1 with OrderIDs and CallIDs and table 2 with CallIDs (that are referenced in table 1) and callDates, how can I find the number of orders within
I am trying to convert data from rows with different lengths into two columns. The value of the first column remains equal to first cell of the row and is copie
I created a macro for Excel which opens a list of all visible sheets in a workbook and goes to the desired sheet as you scroll through the list. The idea is to
How do I copy/paste multiple ranges? The code returns the cell A1. What I need: 1- Search and open all Excel files in a folder with subfolders 2- Copy specific
In the sub workbook_open I'm opening 4 workbooks in the background to be able to have references to them without having them "open". (they are not visible) But
I am attempting to load rows in an Excel worksheet, "List of Golfers", from worksheet "Players". On the Players worksheet I have a table named "GolfTrip". On th
I’m running Excel 2010 & Excel 2003 on a Windows 10 version 21H2 machine. I noticed a change in the appearance of Rob Bovey’s VbaCodeCleaner. A
I'm trying to load my excel file through PHPSpreadSheet library including the charts. At the reader step, everything is working fine and I could without difficu
The code works perfectly fine in IDE but not in normal .jar or in fat .jar? The program works perfectly fine otherwise. Also non-fat .jar doesn't work either. T
I'm trying to print an area of a page to pdf. I select the range but when I try to set the print area I get: Run-time error '1004': Unable to set the print are
I've been looking for different approaches to fix my problem, whether it's with vlookup, index, index /match but couldn't figure it out yet. I'm trying to list
I use maatwebsite/excel export from view, but when my column value contains any special characters like "&", export start sending error "Failed to load ....
I've the following macros working independently of each other (sort of). I need them working together. First I import data from a URL that points to a CSV file
I am working on a project to do the following. Data I get from ERP: After running the code it should look like: I want to implement this logic If there is a v