I have a macro which theoretically works perfectly but I think it is creating unnecessary processing and calculation requirements which then crashes the file. I
I built a VBA Sub that matches an input string with the equivalent string within a large array and returns a specific string which is bounded to the matched str
> STUDENT SCORE VALID DIF 1 83 YES 0 1 77 YES -6 1 2 NO -99 1 66 YES -11 1 100 YES 34 2 68 YES 0 2 98 NO -99 2 61 YES -7 2
I am new to the forum and VBA codes. I have been searching for an answer to this question and am completely lost. I have a workbook that contains around 36 work
I want to link a "TimePicker" housed on an Excel macro enabled spreadsheet (it has three textboxes for hrs, min, AM/PM with associated SpinnerButtons [SBs] oper
I have a VBA User defined function which takes multiple range references for using it in the code. My problem is when I try to use a particular range reference
I got an excel file which should use a query from an ms access file (which is a front end for a ms sql server) But instead of receiving every entry I want to us
so i'm trying to use a macro to look in sheets one code and paste the information of that code , I'm trying to use a simple macro with advanced filters to do th
How do I return an excel file (version: Office365) using FastAPI? The documentation seems pretty straightforward. But, I don't know what media_type to use. H
Is it possible to create a dynamic Excel Pivot Chart title that includes "(Top n)" where n = the value filter row limit selected by the user? I know the chart
I'm trying to return multiple values horizontally into a table from another table (vertical array). I found 2 formulas : = transpose(filter(Result array, x = v
I was using selenium with VBA and there is the current webpage. I was trying to get the bot to select the "exportbutton" ID, but I have already tried Findelemen
I'm a VBA NewBe (this is my first post asking a question on any VBA help site) working on a Property/Expense Management application in excel. the ComboBoxes in
I have multiple xls files in a directory. each file dataframe headers are different but data type is same. 1.xls Location StreetAddress America Pvtld 80
I have an Excel file with many rows and it gets many entries daily. That's why I would like to scroll down the file to last row with data. To find the last row,
I have a log file in csv which has a column contains a list of filepaths separated by comma. I want to split those filepaths into new rows using pyspark(or exce
I can't figure out how to achieve a certain task in my python script. I have a dataframe that contains media coverage for a specific topic. One of my columns na
I have an excel file with multiple sheets, the actual data I need from each sheet is from cell B7 to F38, how can I merge all the sheets' data into one by using
I have two columns in excel, one with a date and one with a rating 'low, medium, high'. I'm trying to write a formula to put in a third column that checks: If A
i want to make a connection with a DBF file through VBA, i have installed all the drivers but i get this error message every time i try to run it Object variab