Category "excel"

Error when pasting in excel from pdf with SendKeys

I am trying to copy a whole pdf document into excel using the following code. The code works perfectly except for the paste part, when it gives me the following

Is it possible to have multiple loops that run independently?

I am trying to insert 2 different ranges "x" amount of times based on the input from the user. The user chooses how many mounts they need "D22" and a range is c

I have a function extracting .JPG from sharepoint URL's but when I use it the data is unreadable

'This code generates files that cannot be opened Sub DownloadPicturestoFile() Dim FileUrl As String Dim objXmlHttpReq As Object Dim objStream As Object Dim Nam

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