Hacker Newsnew | past | comments | ask | show | jobs | submitlogin

> SendKeys

Holy cow why didn't I know about this 6 months ago =|

VBA is something I have had to reluctantly learn. It's a horrid/ancient language. Sorry if someone gets offended at that but to someone who uses a lot of modern development languages/tools it's just very very difficult with near-zero "nice to haves"... you just end up taking this huge lib of code around with you with functions like "inArray" etc.

> As a program, it was horrible, horrible code. As a useful tool for the business, it was incredible.

That's something that's rough for us engineers but can be hedged with great documentation, both inline and and otherwise =)



Is anyone aware of a good resource to learn VBA? All the resources I've seen online are either tutorials for very quick hacks, or assume you have 0 programming knowledge. I would love a "VBA for people who are familiar with at least one other programming language".


You don't have to learn VBA to do this, you can just include windows.h in C and call the SendKeys function.


There's also java.awt.Robot – I've used it a lot for similar things, really neat if you already have Java/Scala code for getting the data to fill in.


I'm interested in scripting stuff in Excel.


I’d recommend learning at least one other programming language, then use the tutorials.


Do you use AutoHotkey ever?


Yep! Sparingly but for some Windows-based tasks you can't beat it. Also it's a solid solution that has great support/devs behind it so it definitely has a home in my toolbox!




Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: