Category "excel"

Use button to add a group of buttons to sheet

In my vba code right now the goal is to add a plus and minus button every time the add button is pressed. As you can see in the gif when the user presses add a

How do I insert a row every nth row in openpyxl?

I have a workbook in which I get data from a program and I was trying to automate some of the tasks, Basically there is data for a game every 4 rows and it goes

VBA script that opens windows explorer and points to a file that copies values from one workbook to another

I have a VBA script that copies and paste data from one workbook to another, but I would like to get my script so when I click run, windows explorer window open

Python mouse and keyboard recorder that switch lines in Excel

I have a Excel file containing data for simulations. Each row is a simulation and contains data that i want to copy and paste into another software at a specifi

Is there a way to download and import multiple .tsv files into excel or access?

I am trying to create a database from SEC filings. The filings come in .tsv files and are structured in folders by year and quarter. Ever folder contains about

vue: Downloading excel files using node-xlsx

I am very new to programming and working on a web project. I used node-xlsx make a button that export excel data. But I got an error "Cannot read properties of

Trying to filter data for each sheet using VBA

I currently have this code : Sub FilterRows() Dim ws As Worksheet For Each ws In ActiveWorkbook.Worksheets Sheets(ws).Range("A1").AutoFilter

Excel API 1.1 - error while adding content to table

I'm trying to create an ```Office add-in`` for Excel but encounter the following problem. This occurred after updating de server. Setup: Excel API 1.1 Windows S

How to save a workbook using a value from a referenced cell as the file name?

I am trying to save a workbook with the value from a cell as the file name. This code will save it as a specific file name, ActiveSheet.SaveAs FileName:="C:\Des

Working code gives error when run on any other PC

I have working code that requests information from a website. When I send the file to another PC and run the code, I get: "Run-time error'91': Object variable

Reset range selection

I track our writers' monthly payments, and have created a workbook with a worksheet including a summary of each writer's pay. The sheet includes a vlookup that

Analysis Services: How to show the original parameters of Pivot Table Excel after computing filter?

When connecting to AnalysisService / Cube with Excel, I have a PivotTable in a Excel Tab. Here it is. And the PivotTable settings is in the Sheet1 THEN I do d

How to speed up code to search many sheets

I have active sheet open (Sheet1). I want to pick a value from C column then go through each workbook and within each workbook there are many sheets. If that va

Replacing text in a chart title

I'm afraid there's no code in this question, but I'm looking for feedback. I have a VBA addin called FlexFind (https://jkp-ads.com/excel-flexfind.asp) which I a

Create a new tab, copy data from another tab, and paste the data (with formatting) in the new tab

I have a tab called "Overview" where it asks me for the name of a project. Once I write the project name, I want a macro to grab the project name, create a new

Check Textbox text is excel valid formula and use that function to calculate in VBA without storing any value in excel sheet

I am trying to learn EXCEL VBA. One of the tasks I am stuck with is how to verify textbox1.text is valid excel formula. I tried Worksheetfunction.isfunction(use

Referencing cells from other sheets

I am trying to extract data from different sheets in a summary sheet. The referencing does not work. Sub Summary_LPI() Dim wkSht As Worksheet, wsC As Workshe

Change date values and retain format

I want to replace a repeating year of dates in a column. I started with a nested for loop in a single module, then I changed the code to be used for each sheet

Inserting a row in a Word table from Excel

I have an Excel spreadsheet that contains information to be put into a Word invoice template. I am able to populate header details, such as client name, address

With only the Select and View Definitions permission on a view, can SQL queries be sent from Excel without needing to type the query each time?

I have views that my users often only need to check for one particular person at a time. To do this, they do the following in Excel 365 desktop: Open a blank wo