2 ms·
Ha - good timing! I've been using VBA today and yesterday actually! Often only a few times a year I use it now but when I do it I feel productive. In case you
by __app_dev__ 7y ago
Ha - good timing! I've been using VBA today and yesterday actually!
Often only a few times a year I use it now but when I do it I feel productive.
In case your wondering I has a previous Excel VBA Macro that I wrote for updating a SQL Server Database based on data in Excel. The macro first has to run checks against data in an IBM AS/400 Database.
I ended up having to pull out the macro to do a bulk update in an ERP. It was faster to do this then re-write in an modern language (especially since I work with the data in Excel first).