Log In
Register
Home
February 21, 2018
Offline
Hi all Gurus
Sorry if irrelevant question.
I am interested in learning VBA for automation of Excel (I put following two questions as sample and reason for learning). Can someone please suggest should I learn Python or VBA for excel automation.
Q-1 Create log (in same workbook but separate sheet) to keep record of name of person ticked checkbox, time and date.
Q2-I have checklist for clients. When we start working for new client we save previous checklist (to new name) and fill the checklist. Is there any way the newly created excel sheet can automatically link to master sheet and fill the necessary cells (as I tick cells in sheet for new client) so that if my boss wants to see progress for all new clients she can just look at mastersheet rather than she has to open each excel sheet separately.
Above mentioned question may help to under the reason of learning (either VBA or Python).
Thanks in anticipation.
Regards,
Azid
See Answer
July 16, 2010
Offline
Hi Azid,
VBA is the tool for automating Office tools. That said, VBA is not executable on the web, so longer term it would serve you better to learn JavaScript which will be executable in both desktop and web Excel. However, currently the JavaScript API for Excel is still in development and therefore isn't a 100% replacement for VBA yet.
Hope that helps.
Mynda
Answers Post
February 21, 2018
Offline
Hi Mynda,
Thanks for your prompt reply.
Do you teach Javascript for Excel.
If yes, cost per course please?
If NO, then any sources please.
Thanks in anticipation,
Kind regards,
Azid
July 16, 2010
Offline
You're welcome, Azid. We don't teach JavaScript for Excel yet as it's not fully developed, but learning JavaScript in general will give you a head start for when it's fully fledged in Excel.
For now, I'd be inclined to avoid using check boxes and instead use text in cells for your log as these are easily read with formulas.
Mynda
1 Guest(s)
