Forum Discussion
Link part of file name to Excel cell
I would like to link part of the filename to part of a cell. The name of the Excel file is Excel Mar Sample. The string in an Excel cell is "MTD Mar CY2021". I would like to like the Mar in the filen...
HansVogelaar Even though I saved as Apr, the link could not be updated.
Excel in Teams is actually Excel for web. It doesn't support VBA and GET.DOCUMENT function, as well as cell("filename"). Moreover, link on the current file, if check it in File->Info, starts from "https://...".
So far I don't know the way to receive the filename in Excel Online, if maybe with Office Scripts.