I think "Automate" tab is a little defective. I can see "Automate" tab and all commands under it avalable as enabled. When I click "New Script" command it say "Office script requires a work or school account". I think I have a personal account ( I don't know all the complicacies about various types of acounts though). If it does not allow office script to be run or created under personal account ( don't know why) then the message is OK. But then the question is why the "Automate" tab appears in the first place and then why all the commands under it are enabled?. I must say it is confusing.
For office automation I still need to be restricted to VBA. But I am really eager to work on office script very much and I can leverage my skill in JavaScript and knowledge of office object model since 90% of my work involves coding in JavaScript..Thanks