Hacker News new | ask | show | jobs
by Zababa 1776 days ago
About tables, do they work when you automate the data entry part? For example, copy from a speadsheet into your spreadsheet with the first macro, and then transform the data with a second? That's 90% of my use case for Excel. (I know that doing this in Python/whatever would be "better" but I have to distribute this to users, and the only thing they have on their computer is Excel, and they're gonna manipulate the data after in Excel anyways).
2 comments
correcthorse123 1776 days ago
I think Libreoffice Calc supports python integration. Maybe that way one could have the best of both worlds. Unfortunately I suppose most users are stuck in the MS garden.
link
Arrath 1776 days ago
They should...I think.

If anything add a 'ActiveSheet.Calculate' call to the end of your second macro and give it a test run?

link