Microsoft 365 and Office | Development | Other
Building custom solutions that extend, automate, and integrate Microsoft 365 apps.
Convert a VBA code to a Script
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(268.8, 37%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPR%3C/text%3E%3C/svg%3E)
Pamela Rubalcaba villalobos
1
Reputation point
Hi guys,
I am new with Scripts, any help is appreciated.
I have a VBA code that works in an excel file but not in a shared file. So I am trying to convert the functions of the VBA code to a script but it keeps showing error.
This is the VBA code:
Microsoft 365 and Office | Development | Other
Developer technologies | Visual Basic for Applications
Developer technologies | Visual Basic for Applications
An implementation of Visual Basic that is built into Microsoft products.
Microsoft Security | Microsoft Authenticator
Microsoft Security | Microsoft Authenticator
A Microsoft app for iOS and Android devices that enables authentication with two-factor verification, phone sign-in, and code generation
{count} votes
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(86.4, 82%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EWL%3C/text%3E%3C/svg%3E)
Wamwitha Love 76 Reputation points Microsoft Employee2021-10-30T04:17:29.65+00:00 To get an idea of what APIs you may need to use in order to convert a VBA solution to an Office Script I might start by trying to record the actions you need to take. Then you can open the editor and see which APIs you might need to call. This documentation provides some instructions on where to find the functionality.
Sign in to comment
Sign in to answer