Jan-17-2020, 06:37 PM
Depending upon what you mean by "process the data" you might greatly benefit from the python pandas module.
https://pandas.pydata.org/
Pandas can directly read an MS Excel file into its native DataFrame object and will provide more functionality than Excel and almost certainly speed up any equivalent analysis.
Another plus to python over VBA is that the skills you learn will continue to be useful as python is going strong while VB is past its prime and barely used anymore (unless you want a job maintaining out-dated, legacy code).
https://pandas.pydata.org/
Pandas can directly read an MS Excel file into its native DataFrame object and will provide more functionality than Excel and almost certainly speed up any equivalent analysis.
Another plus to python over VBA is that the skills you learn will continue to be useful as python is going strong while VB is past its prime and barely used anymore (unless you want a job maintaining out-dated, legacy code).
"So, brave knights, if you do doubt your courage or your strength, come no further, for death awaits you all with nasty, big, pointy teeth!" - Tim the Enchanter