Forum Discussion
workbook and sheet name via formula
Afraid for Excel Online that's only with Office Script, there are properties getName both for workbook and worksheet.
VBA and related functions don't work in Excel Online.
Does Office 365 Excel support VBA?
All versions of Windows desktop Excel from Excel 5 through Excel 2019 support VBA.
This includes the version of Excel installed by Office 365. ...
There is no version of Excel Online, iOS Excel or Android Excel that supports VBA.
Nor does any version of Excel that runs on Windows RT support VBA.
In my humble opinion, it would be good to always have the possibility of VBA in Excel.
All new options such as editing PDF and cloud options, in all future versions, will be require VBA.
Unless someone has already adjusted to Java script ... which I don't hope.
What I don't know is, if you maybe can open from the Developer tab in Visual Basic editor, I don't have Office 365 yet. You can try it, maybe…maybe it will work.
The sequence is in Excel 2016
Click File
Click Options
Click Customize Ribbon
Under the list of Main Tabs, select Developer
Click OK
The Developer tab will now appear on the Ribbon and from it you can open the Visual Basic Editor.
If opening the Developer tab and clicking a button is a little too much work, you can also open the editor with the keyboard shortcut Alt+F11, which works whether the Developer tab is enabled or not.
As I told you before, with the logic of Excel 2016.
Nikolino
I know I don't know anything (Socrates)
The CELL function which works on desktop does not work with online (weirdly), and same is true of VBA.
It's a pretty small detail (CELL formula not working online), not a critical functionality, just annoying to me, because I literally use the same header on every document as a matter of best practice.
- you may always check if function available for online version or not here Excel functions (alphabetical) In particular, what it says for CELL
- you may vote for the idea to add CELL() for the online version here CELL function added to online . In theory more votes more chances it'll be added.
- Perhaps one day functionality of desktop and online versions will be synced, at least that's how I understand Microsoft intention. But with that most probably not VBA will go online but Office Script will go on desktop. That's a long way.