3 ms·
Excel is horrible to program in. Example: I needed to import a bunch of URLs, then pull the query params out and auto-create a SQL query based on those. I was a
by adamredwoods 6y ago
Excel is horrible to program in. Example: I needed to import a bunch of URLs, then pull the query params out and auto-create a SQL query based on those. I was able to do it, but when I entered the Visual Basic editor, it was a whole new word of UI hurt.
- iamacyborg 6y agoThat sounds like probably the sort of thing that shouldn't be done in Excel though.
- adamredwoods 6y agoI like to push software around, but yes, there are better ways to do this.
- dragonwriter 6y ago> Excel is horrible to program in. VBA, and the built-in DE for it, isn't great, but you can program Excel other ways (Office Add-In, xlwings, etc.)