Forum Discussion
BigB4400
Sep 22, 2022Copper Contributor
Help to convert Excel VB to Excel online script
I have the following VBA in Excel that inserts a static date into cell column G when I update the corresponding cell in column A: If Not Intersect(Target, Range("a155:a10000")) Is Nothing Then T...
NikolinoDE
Sep 23, 2022Gold Contributor
As far as I know there is no way to convert VBA code to Office script code, you have to write code yourself. Office Scripts is a TypeScript-based script, not Java.
I know I don't know anything (Socrates)
- BigB4400Sep 23, 2022Copper Contributor
Thanks for the reply NikolinoDE, I had read the link you sent, and am aware there is no utility to convert the VBS to Excel script. I don't have any experience with the online script, and was hoping that someone here with some experience could offer me some pointers, or already had something similar to the simple VBS that I have, that might be able to be used to accomplish my end goal of putting in a static date.
- NikolinoDESep 23, 2022Gold Contributor