Is it possible to run Excel Marcos in ServiceNow

matthew_hughes
Kilo Sage

We've been given a requirement of automating a process that involves manual steps using Macros in Microsoft Excel. We are looking to try and automate the use of Macros and instead use ServiceNow. 

 

I thought I'd ask is it possible to replicate the steps of Macros in Excel and put these into ServiceNow?

 

An example of a Macro that we'd like to put into ServiceNow is:

Sub ClearAllData()
'
' ClearData Macro
'
Application.ScreenUpdating = False

'

Sheets("Raw Data").Select
Cells.Select
Selection.Clear
Range("A1").Select

Sheets("Level1").Select
Cells.Select
Selection.Clear
Range("A1").Select


Sheets("Level2").Select
Cells.Select
Selection.Clear
Range("A1").Select


Sheets("Level3").Select
Cells.Select
Selection.Clear
Range("A1").Select


Sheets("Level4").Select
Cells.Select
Selection.Clear
Range("A1").Select


Sheets("Level5").Select
Cells.Select
Selection.Clear
Range("A1").Select


Sheets("Level6").Select
Cells.Select
Selection.Clear
Range("A1").Select


Sheets("Level7").Select
Cells.Select
Selection.Clear
Range("A1").Select

Sheets("Level8").Select
Cells.Select
Selection.Clear
Range("A1").Select


Sheets("Level9").Select
Cells.Select
Selection.Clear
Range("A1").Select

Sheets("Level10").Select
Cells.Select
Selection.Clear
Range("A1").Select
Sheets("Control Sheet").Select
End Sub

1 REPLY 1

Dr Atul G- LNG
Tera Patron
Tera Patron

No 100% sure, but need to write in script. What these macro do and in which table you want to run.

*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/atul_grover_lng [ Connect for 1-1 Session]

****************************************************************************************************************