Is VBA still worth learning?

BrooksRimes said:
I use VBA with Microsoft Access and do consulting in Access. Often users start something in Excel and it becomes so large and/or complex that it becomes a good candidate for an Access upgrade. Access is Microsoft's desktop database and is included in Microsoft Office Professional version. You can create very user-friendly screens and reports in Access. (SQL Server is Microsoft's enterprise level database) I created an option backtester in Access (similar to Tradestation or Amibroker) because there was no product on the market at that time. VBA is the macro language behind all of the Microsoft Office products.
More...

In short, I have my data stored in SQL and load it into Excel which is used as a front end for final analysis. Basically, a lot of stuff is computed in C#, stored in SQL and then loaded into Excel.

I'm having minor issues - particularly since I'm updating intraday (either automatically or by discretion) - but so far I'm living with it. Issues being speed/stability when loading data.

Is Access both a database and a front-end?
 
d08 said:
This is why you'd use Python. You could use a library and do that with ease, not ask around about it on ET.
More...
I need to go to Coursera and sign up for a course in Python programming (3 months), then spend another 6 months learning how to. Maybe I can find a VBA macro I can plug in and run?
 
ironchef said:
I need to go to Coursera and sign up for a course in Python programming (3 months), then spend another 6 months learning how to. Maybe I can find a VBA macro I can plug in and run?
More...

There's plenty of Python examples online. Why would you need Coursera? But obviously copy-paste is faster than actually learning something. This is true for anything.
 
d08 said:
There's plenty of Python examples online. Why would you need Coursera? But obviously copy-paste is faster than actually learning something. This is true for anything.
More...
Hard to learn without someone holding my hands.

Took me over a year to learn VBA, hard to give it up yet. But thank you for your suggestions.
 
d08 said:
There's plenty of Python examples online. Why would you need Coursera? But obviously copy-paste is faster than actually learning something. This is true for anything.
More...
Maybe you can point me to where to get help:

1. I use a MacBook Pro. Where in my Mac can I find Python programming language?

2. I have a 2011 version of Excel, can Python work with my data in Excel?

Thanks.
 
ironchef said:
Maybe you can point me to where to get help:

1. I use a MacBook Pro. Where in my Mac can I find Python programming language?

2. I have a 2011 version of Excel, can Python work with my data in Excel?

Thanks.
More...

It only takes a web search: Python for OSX

There are Excel libraries for Python that work well but I haven't used them. Why do you need to use Excel at all?
 
ironchef said:
Hard to learn without someone holding my hands.

Took me over a year to learn VBA, hard to give it up yet. But thank you for your suggestions.
More...

https://www.youtube.com/watch?v=Mu1I89BeKxM
https://www.youtube.com/watch?v=yE9v9rt6ziw
https://www.youtube.com/watch?v=vaysJAMDaZw
https://www.youtube.com/watch?v=3cZsjOclmoM

There ya go. About 40 hours of handholding. If you use Linux you can save them to your HD using youtube-dl. Amazon has those "book" thingies, too. Seriously, you can learn just about anything between wikipedia, google, youtube, reddit, quora, and those book things.
 
  • Like
Reactions: d08
d08 said:
It only takes a web search: Python for OSX

There are Excel libraries for Python that work well but I haven't used them. Why do you need to use Excel at all?
More...
Is that free?

I need to use excel because that is all I know and all my data/formula/backtest are stored in excel.
 
You must log in or register to reply here.
Back
Top