Using Excel VBA with Monday.com

Platform discussions
,
1

I want to create VBA in Excel to put the Excel spreadsheet data in a Monday.com board. Does anyone have an example of such VBA? I’m having trouble just getting started. Thanks.

2

Below is the code I have. I keep getting the error: “No Query String Was Present”.

Sub BetterMoveToMonday()

 Dim monday As New MSXML2.ServerXMLHTTP60
 Dim response As Variant
 Dim status As Variant
 Dim query As String
 
 myurl = "https://api.monday.com/v2"
 mytoken = "XX"
 
 argString = "{""mutation"":""{@@@}""}"
 argString = Replace(argString, "@@@", "create_item(board_id: 2739406766, item_name: \""NewVBA\""){ ID }")
 
 'query = "mutation{create_item(board_id: 2739406766, item_name: 'VBA-10') {id}}"

    With monday
        .Open "POST", myurl, False
        .SetRequestHeader "Content-Type", "application/json"
        .SetRequestHeader "Accept", "application/json"
        .SetRequestHeader "Authorization", mytoken
        .Send argString
        response = .responseText
        status = .status & " | " & .StatusText
    End With

MsgBox response
MsgBox status
MsgBox argString

End Sub
3

Hey @Brock! Just hopping in here to see if you were able to find a good solution for this! If not, feel free to email us at support@monday.com and we’d be happy to assist further with this! :blush: