Recommendations for Careers with VBA - VBA heavy jobs?

Hi all,

I can only apologise if this post is not allowed but just thought I would ask feedback from the experts.

I am currently a Business Analyst and have been thinking about progressing my career specifically into remote working.

Are there any suggestions of careers to look out for i.e. Project Mgmt. or VBA Developer?

There are very few of the latter from the above suggestions around so wondered what people’s thoughts are.

My favourite thing to do is problem solve VBA issues and generate dynamic reports and interacting between systems, I don't have SQL or Python or anything like that, my skills are VB, VBA, AutoIt

Thanks in advance
Cheese

The post is allowed but I've moved it to a more appropriate forum and tweaked your title.

I can't remember the last time I saw a pure VBA developer job. Mostly at least one other language is required - SQL seems pretty common - and I think a lot of those types of jobs have shifted towards other languages like C#.

I'm not an IT person, but I was a teacher. For a techie in a school, where data handling and analysis is prevalent, a knowledge of SQL would certainly be advantageous: most educational database software uses SQL (as I understand it), and some of it is better than others in allowing teachers to get what they need out of them in the format they want it. As Pupil Data Analyst at my school, I had to work with the IT team to work round this, and they had been forced to learn SQL. I know that a knowledge of SQL is now mentioned in job descriptions for their jobs.

Conversely, they would have little need for VBA in a school, where, generally speaking, it will be the browser-based version of Excel (if a Windows/MS Office platform is being used) that will be the entry point for most staff, and the browser won't support VBA, of course.

Anyway, this may or may not be helpful.

I think you do - even I went to two of the training sessions at school when the IT team decided to tool themselves up!!!

I forgot to say: my other half worked for a software company providing software solutions for county councils, etc., and all their databases were built using SQL.

I spent 42 years as a professional software developer and project and program manager. As such I have a kind of snooty opinion about going off an learning a language. If you need to know SQL, you don't just need to know the language syntax. For it to make any sense you will need to first learn relational database design.

I learnt relational database design when I decided to teach myself by building an entire exam entries system for myself to use at school in Access (this was before we used school database software that did all of this for us), so when I did a bit of SQL, that knowledge was invaluable. So yes, Jeff, I entirely agree with your point.

Originally Posted by CheeseSandwich

i used to use Access but it seems to have been dropped like a stone....but access was all about relational tables so i think i know where we are going.

If you use Access to learn relational databases then 90% of that will apply to other RDBMSs.