office scripts

Hello all! I have a file that needs daily updates to reflect a new day with specific formatting. I am looking for a script that can find the last row used (Row 11 in the attached image), copy from the last row up to the previous days formatting (up to Row 5 in the attached image), paste over...

Hey Mr. Excel Boards, So, the short question is that, is there any way to display/add the refresh date to an online pivot table? Long question: I / my boss has built a PowerAutomate (cloud) flow that iterates over a bunch of excel documents in sharepoint, then runs an office script in each...

Hello, I am hoping I can accomplish the following. setPrintArea(printArea) Set the print area to the dynamic array on the active sheet. Use same cell X2# on all printing sheets. There are twelve. Twelve buttons, one Script. Has anyone done this before? I read about dynamic print ranges, but...

Hi Folks, I have been asked to generate an online excel spreadsheet and automate some functions that I would normally use VBA for. I've read a bit of intro material, but Office Script seems alien to my brain right now. How would one replicate the following VBA code? Sub setvalue() Dim ws...

I have tried to use the following script from an old message on this board in Office 365 to open a new worksheet and name it with the current date. This code only opens a new sheet with the name "Sheetx" (x is increasing numbers). I would also like to be able to open the new sheet from a...

Hi all, i was working with VBA scripts many years but i really dont get how can i run my scripts into office 365. Specially i did i simple script to count cells in range in multiply sheets. see below. But i completely dont understand how to run it in Office script. Sub SumValueAcrossTabs()...

Office Scripts in Excel on the web - Office Scripts I want to learn the above Tool. Where should I start with? Is there a Book available? Please reply. Thank You. With Hope, Prabhakaran

I hear that eventually Excel will use Office Scripts, which is based on JavaScript. From my research this is only as a preview on the web version of Excel. Will this eventually be available for the desktop version of Excel? Has anyone started to use this? Will there be a means to convert...