Forum Discussion
Solved
VBA-->Script converter
Hi all, I've many excel files containing macros, these files are shared in the cloud and macro are not "allowed". Is there a way to convert VBA in to Script? thanks in advance
Unfortunately, there is no way to convert VBA macros to Office Scripts automatically. You'll have to rewrite your macros in Office Scripts.
May consider to rewrite:
VBA Code:
Sub HelloWorld() MsgBox "Hello, World!" End Sub
Office Script:
function main(workbook: ExcelScript.Workbook) { workbook.getApplication().showAlert("Hello, World!"); }