Run VBA in Alteryx

HI..

I have a VBA code that will pick up from 2 tab in the sheet and doing some calculation to calculate the BOM material cost. I have tried the link that been provided in previous discussion but it doesnt work since the data is too large and the csript is hang. Is there any possible way that I can write the code in the Alteryx and use the input file from the gdrive and the output also is in the gdrive. Pls help to advise. Thanks

Developer Tools

Accepted answers

simonaubert_bd

Hello @hzpetro

Sadly there is no way to use directly VBA in Alteryx.However, you can try both solutions :
-reproducing manually your code with Alteryx tools
-using generative AI to transform your VBA in Python

https://help.alteryx.com/current/en/designer/tools/developer/python-tool.html

-using a cmd tool to execute vba but in your case, it won't help
https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Running-VBA-Script-in-workflow/m-p/567698#M124419%3Futm_content=en&utm_source=designer_2024.1.1.17_trial-False&utm_medium=global_search

Best regards,
Simon

All comments

simonaubert_bd

https://help.alteryx.com/current/en/designer/tools/developer/python-tool.html

Best regards,
Simon

hzpetro

Hi @simonaubert_bd

Let me try with both of your suggestion. Thanks for the help and advise. Appreciate it

goyolix666

Sub RenameSheet()
Dim ws As Worksheet
Dim newSheetName As String

' Set the worksheet you want to rename
Set ws = ThisWorkbook.Sheets("Sheet1") ' Change "Sheet1" to your sheet name

' Set the new sheet name
newSheetName = "NewSheetName" ' Change this to your desired sheet name

' Rename the worksheet
On Error Resume Next ' Ignore error if the name already exists
ws.Name = newSheetName
If Err.Number <> 0 Then
MsgBox "A sheet with the name " & newSheetName & " already exists or the name is invalid.", vbExclamation
Else
MsgBox "Worksheet renamed to " & newSheetName
End If
On Error GoTo 0 ' Resume normal error handling
End Sub

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703