Entries for 'Boris Cherkasskiy'

Recently, I needed to read a command line parameter within a VBA code (it's for an Iconics SCADA application, but I developed it with Excel VBA which is essentially the same). It doesn't sound like a big deal but there were a few not-so-obvious tricks that I thought were worth sharing. I started with the simplest solution using a "GetCommandLineA" Windows API fu... [Read the rest of this blog...]
Resurrecting the Antique Pressure Gauge to Display Internet Bandwidth
Who doesn't like old technologies? For example, a Motorola cell phone as heavy as a brick and built to last centuries (literally)? I do like old stuff, my dear readers. That's why when one day I came across a cool looking (and rightly priced!) antique pressure gauge on eBay I bought it with very little hesitation. Presumably, gauges like this had been used on steamboats and locomoti... [Read the rest of this blog...]
Tired of "Hands Free?" - How About a "Hands Full" Solution?
I used to have an old Motorola cell phone, actually it wasn't even a phone, back then it was called a DPC - "Digital Personal Communicator", which in my mind sounds much more scientific than a modern "cell phone". This is used to be an awesome piece of equipment back in its day (actually it was the smallest  phone in 1989). However, it's quite useless now since it does not support m... [Read the rest of this blog...]
How cold is it in Russia?
I am getting questions like "you are from Russia, it must be cold there" quite often for obvious reasons. Despite the fact that Russia is huge and includes geographic zones from subtropics to arctic circle I've decided to compare climates of USA and Russia. When someone says "Russia" this probably means "Moscow", where roughly 10% of Russian population live. It doesn't make much sense to compare ... [Read the rest of this blog...]
Editing underlying data in MS SQL Reporting Service (SSRS)
We used  MS SQL Server Reporting Service (SSRS) on multiple projects as web-reports engine. I liked it a lot because it allows to design quite complicated reports at no time. But sometimes I wish I could edit data viewed in the report (like edit row comment, etc). Although it's not possible to edit report data using standard SSRS features, but there is a way around it.

Shows how to populate Iconics/Genesis32/GraphWorX32 drop-down list (Statefield) using VBA

[Read this blog...]