All Questions
6
questions
6
votes
3
answers
1k
views
Safe Windows API Timers for Excel
Update Feb 2023
This solution is no longer maintained here or on GitHub, mainly because I do not need a timer solution anymore. As seen below, the only purpose of this approach was to get a reliable, ...
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
1
answer
868
views
Collecting all instances of an Office application (Excel, PowerPoint, Word)
A project of mine required me to search for certain workbooks in open instances of Excel. I found this article Code to get Excel, Word, PowerPoint from window handle which returns the applications ...
2
votes
1
answer
664
views
Excel - Visual Basic For Applications - Mastermind Game
For those who are unfamiliar with the game:
https://en.wikipedia.org/wiki/Mastermind_(board_game)
A link to the workbook:
https://github.com/Evanml2030/Excel-Mastermind
Had trouble getting the ...
2
votes
0
answers
413
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
0
answers
2k
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 ...