![]() ![]() ![]() peter h on Teardown: Cooler Max Liquid Cooling System.James Finch on PETamentor2 Is Latest To Turn Bottles Into Filament.This Week In Security: Npm Timing Leak, Siemens Universal Key, And PHP In PNG 12 Comments ![]() Posted in Software Hacks Tagged excel, serial Post navigation If you’re looking for other ways to leverage this Excel feature, consider watching movies at work or building a virtual machine inside of your sheets. It’s a handy trick that I have used myself several times, and does a nice job of explaining how the code works, and how to integrate this code into Excel. With a bit of VBA, you could create a spreadsheet that talks to the instrument directly, grabbing the data and processing it as required straight into the spreadsheet. Imagine, for instance, that you are logging data from an instrument that has a serial port (or even an emulated one over USB). Since then, it has evolved into a powerful (if sometimes frustrating) language that offers a subset of the features from Visual Basic. ![]() The scripting language is called Visual Basic for Applications (VBA), and it has been a part of Microsoft’s Office suite since 1993. But this spreadsheet has a rather powerful scripting language hidden away inside it, which can, with a little coding, be used to send and receive data over your serial port. When you think about serial communications, Microsoft Excel isn’t typically the first program that springs to mind. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |