Forum Discussion
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
Target.Offset(0, 6) = Now
End If
The VBA works great in my desktop version of Excel. But I am accessing the file in Teams, and I understand that Teams is running Excel Online, and cannot access the VBA. I have tried formulas that modify the cell in column G when there is a value in column A with a Today() formula, but the formula remains, and each time the page recalculates, it updates the values to a new time, not the time column A was actually modified. I need it to be a static date, and I can't do that with a formula.
3 Replies
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)
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.
