Questions tagged [excel]

Microsoft Excel is a commercial spreadsheet application written and distributed by Microsoft.

Filter by
Sorted by
Tagged with
1
vote
1answer
728 views

Data scraping from Internet with Excel-VBA

I have built an Excel application, which gets all the titles of books from Amazon.com, which it is asked to do and scrapes the following data out of them: Book Title Author Price What do you need to ...
1
vote
2answers
91 views

Tab month tracker

The code works; the problem is in the processing. I feel like the code can further improved and I believe the answer is Arrays however, my knowledge is very limited. Here, I loop through ~ 1000 ...
1
vote
1answer
43 views

Function to get constants of range

The following small function receives a range and returns it with only the cells that contain constants or Nothing if there's none. ...
1
vote
2answers
67 views

Test blank cell and out put phonetic (text)

I have this code which first checks for blank cell in Column B, and then blank cells in Column F. If the results is Yes-No, then it prints the phonetic into F. Can someone review the code, please? I ...
1
vote
1answer
77 views

Write to a new, modified Excel file from an original one

I noticed that I've a HUGE bottleneck in this following function of mine. I can't see how to make it faster. These are the profiling test results(keep in mind that I'm using a PyQt GUI so times can ...
1
vote
2answers
9k views

Excel instances: release and kill

Please check my code below. I don't have any problems but I'm not aware how far the code will work, release and kill excel instances.. ...
1
vote
1answer
86 views

VBA Excel substitute function for multiple conditions at once

I use the SUBSTITUTE() function in my VBA code. In Excel formula, we can nest it as shown in the thread below: https://stackoverflow.com/questions/22313965/how-can-i-combine-multiple-nested-substitute-...
1
vote
1answer
89 views

Looking for a more condensed method of assigning values by using arrays and fixed ranges

I currently have a Template Workbook set up that has charts and graphs updating when new data is plugged into the Data Tables. The Data Tables are fixed ranges, and won't change. The Macro is within ...
1
vote
1answer
96 views

VBA Class instance to simulate a framework

Objective: Simulate namespaces in VBA and access functions like if you had a Framework setup or at least that was what I ...
1
vote
1answer
935 views

VBA loop optimization

Hi folks: I posted a SO (https://stackoverflow.com/questions/57541246/optimizing-vba-function-loop) and was told to ask here. I am starting to think that rather than relay on excel as my data ...
1
vote
1answer
50 views

Clean up code that transfers data from DB2 Server to Excel

The code below is functional and works as expected, but I imagine there is a better way to test for the error that I am testing for . The scenario is that data is transferred between two different ...
1
vote
1answer
58 views

Bookkeeping Coding - Check and Create Tabs, Copy filtered Data in Loop

As said, this is take 2 (see linked for Take 1 for my massively beginner code: https://codereview.stackexchange.com/questions/223236/) As an overview: I manage the bookkeeping for 40+ companies in ...
1
vote
1answer
40 views

Django export to xls format

I'm working on a Django project and I'm wondering if there is any way to improve the process time to export my data to xls format. Actually, it takes between 43 seconds and 49 seconds to create the ...
1
vote
1answer
72 views

Improving speed of data clean process in vba

My code does exactly what I want it to. However, being relatively new to VBA, I feel it could be a lot more efficient - namely I think I have overused loops and worksheet functions which are slowing ...
1
vote
1answer
83 views

Merging records from one spreadsheet into another

I have created the code below that compare two spreadsheets . It initially compares the range of value from sheet1 ("Status") to sheet2 ("Interface") . Whenever a range matches with the ranges present ...
1
vote
1answer
66 views

Loop whose endpoint (?) change during the loop [closed]

I have a loop which insert rows on specific cases. The loop goes through ~2000 rows and insert about 500. Due to the inserted rows it doesn't loop the full range I want. I have solved that problem by ...
1
vote
1answer
563 views

Loop through different controls and enabled the state of the whole group VBA

I got the below code that is looping through all controls and changing the state in a after update event and enables new row for user to use. Everything works fine but i'm just wondering whether there ...
1
vote
1answer
142 views

Space Invader game written In VBA, 3rd iteration [closed]

Here is a link to the workbook, classes, modules and forms: https://github.com/Evanml2030/Excel-SpaceInvader Positive: I have decoupled the view from the control / presenter. I have implemented what ...
1
vote
1answer
248 views

VBA Script to Remove Duplicates

I'm curious if there's any way I can substantially improve its speed (it runs through >200k rows). I think I'll most likely need this once, so please bear with me since it probably looks terrible. ...
1
vote
1answer
1k views

Read unstructured Excel payslip and export to structured Excel table

I've not used this site before, I would like to get opinions on the code I've completed for my first 'program' in Python. I would like to understand how 'good' it is and where it can be improved, ...
1
vote
2answers
907 views

Matching a checkbox caption to a cell's value

There are 30 checkboxes that need to have their caption compared to a cell value. The basic code is repeated 30 times for 30 different check boxes The only Lines that Change per CheckBox are the ...
1
vote
1answer
64 views

Store account numbers as text

I wrote this code to make sure account numbers (accounting), which are numbers, are stored as text in the range. Replacing r.value by ...
1
vote
2answers
379 views

Retrieve data from eBird API and create multi-level hierarchy of locations

As you may know, I like birds. The Cornell Lab of Ornithology has a tool called eBird where you can submit records of the birds you identified. I recently learned they have an API that I can query, ...
1
vote
2answers
1k views

VBA UDF SUMIF with Array Parameters

I was trying to give SUMIFS3D User-Defined-Function a nice review and ended up getting pretty side-tracked trying to figure out how to pass some parameters by array and whether or not I could send a ...
1
vote
1answer
70 views

Copy/paste values on two sheets

I'm trying to copy values from one sheet to another sheet if a value exists. The code runs great on around 500 rows but very slowly on 5000 rows. Is there any way I can speed it up? ...
1
vote
3answers
64 views

Substitute Excel-Workbook reference for another

I have an Excel-Workbook, where we have an sheet where we consolidate data. Basically we link to other Excel-Workbooks. I wrote the following Macro, in order to update the path and filename. We cannot ...
1
vote
2answers
68 views

VBA userform loop to gather numbers from cells on an Excel sheet

I am working on a userform and have everything working the way it should but it's taking a little longer than I would like. It's looping through 42 labels for each ...
1
vote
1answer
166 views

Order columns when sending email with excel

I have an excel that sends an email with all rows with the same name in column (hotel) from sheet list. I wanted the user to have the possibility to choose which columns are sent and how the data is ...
1
vote
3answers
487 views

Excel VBA Retrieving a Specific Pattern from String

The following VBA code is in response to a SuperUser question which I found interesting. What I'm looking for in a response? Code cleanliness. Can I do more to make the code easier to read and ...
1
vote
1answer
132 views

Excel: displaying an array, works fast for one array, slow for another

I have a program that makes use of two arrays of Clients. It runs N simulations: for example, ...
1
vote
1answer
314 views

VBA script to add formulas to Excel is running slow

I have written the following VBA script that searches for a text string in column CI and if it finds it the specific text the script adds a formula to a series of cells. The script itself runs ...
1
vote
1answer
722 views

Fast edit of Excel CSV format file and save to specific folder VBA

The below code is working I just need a review as there are somethings that I think I might have done wrong. The code will edit the raw data of an excel CSV comma delimited file moving all text using <...
1
vote
2answers
6k views

Converting an Excel range into an array

I'm iterating through a list of possible values that reside in a named range on a worksheet. Since accessing ranges is slow, I wanted an easy way to convert them to an array and came up with the ...
1
vote
1answer
6k views

Excel-to-JSON parser

I just wanted to build a simple converter from an XLS Excel file to JSON. I have predefined JSON format. All fields except of two - are just simple mapping from Excel to JSON. The two fields have a ...
1
vote
1answer
149 views

Code to analyse text get stuck if too much data

I've made the following VBA script to analyse text recurrence in a huge batch of descriptions. For a small part of the batch the code run smoothly, but when I include everything it tends to loose ...
1
vote
1answer
5k views

Creates an Excel inventory from Cisco Show Version text files

This has been written for network engineers to be able to create an Excel inventory of switch/router device info from a folder of 'Show version' .txt files. I've put it here to help me learn about ...
1
vote
1answer
80 views

Fancy new LAMBDA functions with variable number of arguments to mimic native methods - no VBA

The TEXTJOIN function has a really nice interface: =TEXTJOIN(delimiter, ignore_empty, text1, [text2], …, [text252]) ... where ...
1
vote
1answer
58 views

Altering spreadsheet data

I have the below code that helps me do some formatting. But I want to increase the efficiency of the code by making it faster. Below are the formatting steps of the macro. Convert "Q" and "S" column ...
1
vote
1answer
41 views

Populates Data from one Workbook to Another

Another code clean up I am working on. I have been breaking up my code based on things I have learned here on CR. The code below all works and functions as expected, but I know it can be streamlined ...
1
vote
1answer
98 views

Comparing information to a directory of active enployees

The code is doing everything that I need it to. It's taking much too long though upwards of a couple minutes to complete the macro. Does anyone know how I code optimize this VBA code to run quicker? I'...
1
vote
1answer
71 views

Remove row when everything in the row is same

I have a code that will delete the row if the entire row is exactly the same. So if in row 1 I have 100,200,300,400,500,600 in column A,B,C,D,E,F respectively, and in row 3 I have the same thing, it ...
1
vote
1answer
65 views

Look for existing pivottables and change date/year colums based off the “Value” filter

We have a macro that updates all dates/years in all our pivottables (around 100 of them pulling out data from our OLAP cube) based off of a "Master Date" at the top of our sheet (which is being ...
1
vote
1answer
96 views

VBA Copy and Delete Rows loop optimisation

I'm trying to identify which cells in Column C in a spreadsheet of data are dates and if they are, then check if that date is older than 2 years old. If the second condition is met then the below code ...
1
vote
1answer
94 views

Vba to create a new column and insert array formula

My below code is the slowest sub in my workbook. I can't set it to put the Array in immediatley, because the mode is calculated incorrectly (calculates for just one ...
1
vote
1answer
52 views

Merge info from two sheets info one list

I've created a code that works but takes time to run. Is there any way of making this code work in a more efficient way? In short terms I want to: make a new copy of sheet 1 and 2 Select the row ...
1
vote
1answer
195 views

Generating a data validation list and sorting it alphabetically

The following code clears 11 columns that contain lists that are used for data validation on another worksheet. This list is constantly changing due to records being added/removed from the source data....
1
vote
1answer
52 views

Excel custom cell style remover

When you only want a couple styles from a workbook but not all of them it's easier to merge styles then remove those you don't want. How can I improve the form or the backing code? Userform with ...
1
vote
1answer
93 views

User form that searches a spreadsheet

I have this userform that looks up into a sheet. The problem is that when there are a lot of rows to look up it takes too long to execute (for example 100 thousand rows). Is it possible to reduce the ...
1
vote
1answer
54 views

Sending data from sheet to other sheet in Excel (from a dispatch note to some records)

I have this code to save data into some records. It is a little slow, so how can I make it faster? To the first record (sheet MOV MERCADERIA) it copies 23 columns ...
1
vote
1answer
1k views

1
16 17
18
19 20
22