Questions tagged [excel]
Microsoft Excel is a commercial spreadsheet application written and distributed by Microsoft.
111
questions with no upvoted or accepted answers
29
votes
0
answers
1k
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 ...
19
votes
0
answers
1k
views
Progress Bar for Excel
Any future updates can be found at Excel-VBA-ProgressBar
What I've been using so far
For the last 6 years I've been using a progress form which I wrote in VBA using just Windows API calls. The code (...
8
votes
0
answers
756
views
A VBA program to quantify the performance of code execution timers
Motivation
I am interested in optimising the execution time of code with short (fast) execution times on the order of microseconds (µs), but that will be used with high frequency (e.g. like ...
8
votes
0
answers
4k
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 ...
8
votes
0
answers
1k
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. ...
8
votes
0
answers
3k
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
0
answers
348
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
0
answers
105
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
0
answers
129
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
0
answers
632
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
0
answers
929
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
0
answers
92
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
0
answers
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
0
answers
822
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
0
answers
453
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 ...