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 ...
4
votes
0
answers
138
views
Print apartment mailbox lists from excel
Update
Due to the fact that the client's version of excel does not support VBA, I have moved on to a C# excel interop solution which has been reviewed.
The test data has been added at the bottom. The ...
4
votes
0
answers
83
views
Scraping and filling out a time-off request
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 ...
4
votes
0
answers
47
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
0
answers
586
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 ...
4
votes
0
answers
73
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
0
answers
71
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
0
answers
886
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
0
answers
78
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 ...
4
votes
0
answers
925
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
0
answers
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, ...
4
votes
0
answers
112
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
0
answers
391
views
A vehicle database in Excel
I'm looking for some help. I'm new to coding and have started creating this Vehicle database program in Excel for a friend to use.
He is wanting to be able to see all vehicles he owns, when ...
3
votes
0
answers
203
views
Updating VBA code from a central repository in distributed Excel workbooks
I wrote this to help manage the code in a bunch of distributed workbooks. Maybe someday I will re-write this as an add-in, but for now, I just needed a way to manage the code without having to ...
3
votes
0
answers
419
views
Evaluate performance of DLL calls from VBA
While playing with a VBA project involving Windows APIs, I have noticed some odd behavior: API calls under Excel 2016/VBA7/x64 appeared to be much slower than under Excel 2002/VBA6/x32. Since I ...
3
votes
0
answers
81
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 ...