Questions tagged [excel]
Microsoft Excel is a commercial spreadsheet application written and distributed by Microsoft.
123
questions with no upvoted or accepted answers
24
votes
0answers
429 views
Pacman implemented in OOP VBA
What?, Why?
I have been inspired by several other posts on the topic of OOP implementations in VBA to try and create a Pacman clone. I think this task is not all that hard in most languages; but, I ...
8
votes
0answers
1k views
Bringing The System.Text.StringBuilder Up To Lightning Speed In The VBA
After having to swap the feature rich System.Text.StringBuilder for the very fast but very vanilla A lightning-fast StringBuilder, I decided it was time create a ...
7
votes
0answers
2k views
Responding to Events of Dynamically added Controls
I was asked for an example of a class to wrap dynamically added controls as I suggested in this Answer. Although it is out of the context of a Code Review, I thought that it would make an interesting ...
7
votes
0answers
259 views
Web Battleship -The Unofficial Battleship UI
I've written my own UI for Mathieu Guindon's VBA Battleship (Battleship UI: GameSheet) which uses a webpage in a WebBrowser control for the View.
Webform: Userform
...
6
votes
0answers
66 views
Shape Text Formatter Class a Builder Pattern
The preeminence is to have every method of the formatter return the formatter as a reference. This allows it to add and format text in chain. Such as:
...
6
votes
0answers
108 views
An over-the-top approach to data entry
My goal: to make the already easy task of filling out an excel sheet 1% easier by putting in hours and hours of effort. On a more serious note, I'm currently developing a system to manage inventory at ...
6
votes
0answers
630 views
IndexedArray Class: Uses a Dictionary Keys to Index a 2 Dimensional Array of Values
This class encapsulates a 2D Array and a Scripting Dictionary. Values are add or returned from to the Array using a Key and a ColumnIndex, e.g. ...
6
votes
0answers
361 views
Office CommandBarButton Icon Browser in the VBEditor
Frustrated with the solutions that I found online I decided to write my of Icon Browser. From the onset I decided that my Icon Browser should work from the VBEditor and not show any of the thousands ...
5
votes
0answers
315 views
safexl - A Python / pywin32 Excel Application wrapper
Thanks in advance for your interest in my first PyPI project.
While there happen to be a number of projects out there to help with creating & consuming Excel workbooks, I was unable to find one ...
5
votes
0answers
78 views
Parsing Long Excel Report Files for Predefined Results
I work as an IT intern in a multinational and I was given a tedious task of combing through a 2500+ long multi-column excel report file in search of inactive servers.
Here's a sample row from that ...
5
votes
0answers
63 views
Search for used Range.NumberFormats in Excel workbook
On an overly abused workbook we've hit the limit and NumberFormats can no longer be added. If we do want to add more we need to consolidate current formats. My code ...
5
votes
0answers
1k views
Multithreaded Excel + VBScript Timer: Snake Game Demo
Multithreaded Excel + VBScript Timer
After reviewing these post: Snake in Excel in… VBA? and Drawing a snake using arrow keys in Excel using VBA, I decided to work on creating a VBA Timer.
The ...
5
votes
0answers
694 views
Converting multiple excel files in multiple folders into CSV
The whole project is quite large, involving parsing the CSV-files, validating them, exporting them to a database and such, but my code in question involves subset of the project: converting multiple ...
5
votes
0answers
377 views
Scraper for parsing, downloading, and setting images beside each link in an Excel file
I've written a script in VBA which is able to parse image links from a website, download and store them in a local folder and finally set those images beside each link in an Excel file.
As the script ...
4
votes
0answers
41 views
Sheet display in function of date and time on open and save (2)
Since I had to almost start all of the code again with first refactor and an eye opening advice on a random Overflow question, here it is again:
This is a code that selects the right sheet according ...
4
votes
0answers
520 views
Excel Chart - Crosshair cursor lines with VBA
Submitting for expert review.
I am trying to create a Chart - Crosshair cursor in excel chart sheet. Chart - Crosshair cursor lines are two lines (one horizontal and other vertical) moving along with ...
4
votes
0answers
66 views
Combine filtered or hidden cells
Purpose of the code:
I have 3 Excel files to deal with.
Those file have already been filtered or hidden because the content is very large. And I only need part of the content for every excel files.
I ...
4
votes
0answers
62 views
Edit Excel through MS Access
I have an Access macro that runs AfterUpdate of a form. It opens an Excel workbook and edits a few cells. I have It working the way I want, but the problem is that ...
4
votes
0answers
740 views
Node JS | From Excel to Json
Intro -> I have to convert an excel file, which comes usually in this way:
to a Json file that must looks like this:
...
4
votes
0answers
564 views
So what if the “View” in an MVC isn't a Userform, but is the Worksheet?
So I've been following the discussions around VBA as an OOP language and the applicability of various design patterns, such as MVP or MVC. Excellent postings on these topics are extremely informative ...
4
votes
0answers
1k views
Using Excel Cell StyleElements to Style HTML Document
CellStyleCSS class creates css based of Excel Workbook CellStyles. This class is used in conjunction with TagBuilder class, ...
3
votes
0answers
72 views
Modeling data from Excel sheets to parse to Excel sheet
Background:
I have close to 50 excel files - I cannot change the data source - and I steadily get more.
My task is to make sense of all that data and, lo an behold, save that as another excel file (I ...
3
votes
0answers
60 views
Taking time off of taking time off
In my ongoing quest to automate everything I have to do at my job, I've decided to learn how to do webscraping with VBA. I wanted to start with something easy, so the following simply fills out a ...
3
votes
0answers
76 views
Setting a forecast for 2,5k workers intraday for a whole month
I'm working on a large project that requires a ton of data to be processed. I was thinking that using classes would be the best way, and it is, until it has to dump out the memory at the end of every ...
3
votes
0answers
116 views
Looking for more efficient VBA to Move data from Teradata to Excel
I have a simple macro moving data from Teradata to Excel. The process normally takes me 10 minutes to perform manually, however the macro can run for hours sometimes. This is making the macro seems ...
3
votes
0answers
23 views
Speeding up a complex array function in excel
I have a complex array function that takes way too much time to calculate, which is why I'm looking for ways to make it more efficient. Basically, I have a transaction sheet in which I list all goods ...
3
votes
0answers
108 views
Rich data types - boolean object
Context
You can probably skim most of this, it's unlikely to be useful for a review and is just for background info. Also download the files
I've tried to create a ...
3
votes
0answers
2k views
Alternative for VLOOKUP/Index-Match in VBA
I am sharing this function I wrote with the community to provide an alternative to slow VLOOKUP and/or Index-...
3
votes
0answers
624 views
Copying content from Excel into PowerPoint as a picture, with error handling
The code below works, but I want to ask if my solution is adequate or if there's something I should structure differently. If it's alright, I'll apply the same code in other subs.
My code copies ...
3
votes
0answers
242 views
Converting VBA Add-In to C# VSTO. Code following button click event
This is my first program with C# and VS and was originally a VBA Add-In I wrote. I have embarked on this as a learning exercise. The code does work and provides the desired output in a new workbook.
...
3
votes
0answers
57 views
Code runs slower when executed from ribbon compared to directly in module
We use third party addin that downloads market data from the internet into a workbook. The addin works with custom functions that begin with CompanyAddin. For instance, a formula in a cell could look ...
3
votes
0answers
235 views
Retrieving data in multiple formats from Excel with Python
Scenario: I have an excel file that contains some data in the first sheet. That data can be simple strings on a cell or CheckBoxes (marked or not).
Data example:
...
3
votes
0answers
438 views
Document “Search Engine” in Excel
I've created a somewhat "Brute-force search engine" based on a document's filename, as well as an additional keyword that describes the said document. I had to make one as my company's resources are a ...
3
votes
0answers
131 views
CheckedRange Class
This class is used to make Excel Cells behave like Checkboxes. Clicking the cell raises a CheckedRange_Clicked(Target as Range) event and toggles it's value ...
3
votes
0answers
196 views
Excel VBA to download from IE Database Stops Responding
first time using Code Review, although I have been active on StackOverflow, hope I'm in the right place.
I am putting together Excel VBA code that using information from various columns on a ...
3
votes
0answers
98 views
Comb Sort Multi-dimensional Array on Key
Previously: Comb Sort in VBA
I've been running two different comb sorts (on arrays) depending on whether I want to sort numbers or strings and I figured I would give using ...
3
votes
0answers
43 views
Getters, constructors and eval
I'm trying to parse an object generated from an Excel file. The output lists each cell with its contents. If the cell is just a number then it remains a number but if the cell contains a formula (has ...
2
votes
0answers
30 views
Speeding up my Python code for reading from Excel, performing geospatial analysis and writing to Excel files
I have written a Python snippet that reads lat and long stored in an Excel file. Converts them to a point which is then used to perform multiple geospatial analysis including buffer, intersection, and ...
2
votes
0answers
38 views
Create a distribution from .xlsx file using Java
I have an Excel file with 2 columns, names and numbers. I want to know for each name what is the probability for each number. I prefer to do it in Java so I would be able to combine it with the rest ...
2
votes
0answers
355 views
Extracting Excel cell format with Microsoft.Office.Interop.Excel in C#
I am trying to fetch the format (e.g. background color, border settings) of each cell in Excel file with Microsoft.Office.Interop.Excel class. I know that there are many tools could be used well in ...
2
votes
0answers
51 views
Generic function for interpolating missing values in power query
I have written a (relatively) generic function for interpolating values in power query (also useful for power bi and m code).
I am looking for any improvements or input, but especially:
speed
handle ...
2
votes
0answers
107 views
Copying Data from multiple workbooks -> Into One Worksheet (continuous data)
I have a macro created by my predecessor that I run on a monthly basis. However, it does take a while to get through, and I would like to clean it up for efficiency please.
It copies data from ...
2
votes
0answers
36 views
VBA Excel bulk data loop for few columns at once
Good afternoon,
I have a set of working code, which works as a loop between values i = 0-90 step 0.25. It gives 360 combinations exactly.
I used to do this loop separately column by column. It takes ...
2
votes
0answers
132 views
Optimizing the openpyxl program
Purpose of the code:
Let's say I have 3 excel files to deal with.
Those file have already been filtered or hidden because the content is very large. And I only need part of the content for every ...
2
votes
0answers
1k views
Resolve parent child hierarchy in Power Query M code with sorting columns
Based on this article
And this question posted on the power bi forums
Objectives:
Resolve a hierarchy (parent - child relationship) in Power Query adding levels and their corresponding sorting ...
2
votes
0answers
55 views
E-Mail Automatisation Project with smtplib but did not use MIMEMultipart
The goal of the project is to automate sending the same e-mail to a list of people with the same text (except the salutation "Dear Name of Person") with an HTML signature and a PDF attachment.
For ...
2
votes
0answers
75 views
Intersect Method Slows Down Code In Large Selection Of Cells
I have picture in certain cells. When I run following code (With Intersect Method) in smaller number of selected cells, it runs correctly but when the number of selected cells increase - say above ...
2
votes
0answers
91 views
VBA code to account for multiple users too heavy on save actions
I have a worksheet I use with a small handful of colleagues on a daily basis to share information with about orders we place. To make sure we always have the same up to date info we use a shared excel ...
2
votes
0answers
132 views
VBA Array Functions: insert element, remove element
An extension to array functions I am building for my snake game. This one allows you to remove / insert particular elements.
https://github.com/Evanml2030/Excel-ArrayFunctions
API CALLS
...
2
votes
0answers
1k views
VBA array functions: push, pop, shift, unshift
I want to write my snake game procedurally, using as much windows call as I can so as to practice. Looking into GetAsyncKeyState to capture keyboard inputs and play sound functions. Also making a ...
