Tags » Vba

Get FileType And Executable File Path Of A File

Ever wondered if you needed the FileType and Executable File Path of a particular file? Well, I had to. So, I started to look into my famous, all time (24 X 7) library – internet. 449 more words


Making Changes to Many Forms In Access

Although generally I prefer to create custom interfaces for my databases using fully developed programming languages like Python or C#. I prefer to have full access to their computational capabilities and in particular their… 322 more words


New Accumulator Test for Excel-based Vocabulary Learning Tool

I have added a new “Accumulator” test to Vocab Book, the Excel-based vocabulary learning tool I wrote last year. The new test simulates a tried and tested learning method: Imagine a vocab book in two columns with English words or phrases on the left and their target language translations on the right. 135 more words

Code And Apps

42. Macro Bliss

It’s a happy day,
I have just found out a way,
To code VBA.

– MxS


There's a new duck in town!

…and it rocks.

The past few months have been tough. We were facing some serious ANTLR grammar bugs, and our identifier resolver had even more serious bugs, which meant false positives in code inspections, a rename refactoring that wouldn’t always rename all references, and a  356 more words


Getting totals from saved reports

So after I’ve run the loop from the previous post I’m left with 8 workbooks sitting in a folder (that’s two values of parameter 2 for each of the four values of parameter 1). 241 more words