4 ms·
does it have regex search though?
by flamedoge 10y ago
does it have regex search though?
- JoBrad 10y agoIt's pretty easy to get RegEx exposed in Excel via VBA/extensions
- valarauca1 10y agoThis is the big key. A few short VBA macro's can give you regex's and cell swapping. Now you can conditionally swap the programs in other cells, via the contents of other cells. You have a Turing Complete spread sheet.
- dsp1234 10y agoAt one point, VBA in Microsoft Word was my only available programming outlet. I was able, easily, to access DirectDraw and create a faux screen saver. DLL imports are available in VBA, so the entire win32 API is available (in addition to the normal Office automation stuff like sending email, modifying spreadsheets, etc)
- eon1 10y agoYeah, in a similar situation right now and I find the DLL thing is relatively unknown and incredibly powerful if used well. Recently this 'robotics' evangelist keeps trying to rope us into spending a few mil on his automation and I keep showing him up by automating the same stuff right out of Excel for little to nothing.