Seth, thanks for following up on this. I agree that not being able to run EmbedCode results in google spreadsheets is a problem. I'll try to get the developers' plans for future development.

Just for fun, I set up some Javascript code to create a function in google spreadsheet. I know almost nothing about Javascript, so perhaps this could be done better. First, I create and deploy an APIFunction in Mathematica.

CloudDeploy[APIFunction["x"->"Number", #x^2 &], Permissions->"Public"]

Now I go to google spreadsheet tools/script editor and create a function to call this API. Note that I have copied and pasted the url from the deployed api and specified the variable's name ("x").

function myapi(x) { 
    var url = "http://www.wolframcloud.com/objects/ed9022d0-e195-4265-96c4-1d7b0d0f68b8";
    var args = {"method" : "POST",
                "payload" : {"x" : x}};
    var response = UrlFetchApp.fetch(url,args).getContentText("UTF-8");
   return response
}

Then in my spreadsheet, I just call the function in a cell with =myapi(-input-), where input can be a number or a cell reference.

Granted, this is a trivial case, since there is a single input variable and the output is just a string. But it does work! I expect that extending to multiple input variables or different types of output would not be too hard.

Hi Chad, Thanks for the tip. It does bring be a step closer but the problem remains. The problem is that VBA code is quite different especially for the `POST´ command. Cheers, Wouter

Dear All, Thank you very much for these pieces of code. They are very helpful! One extra question though: How do I upload a (text) file in VBA using the POST method for instance using the FormFunction as a cloud object.

I've tried a lot of stuff, the form works in my browser (ie it can upload a text file, But when I POST the file in VBA (excel) I get my original form back instead of some response the function should give.

Thanks very much in advance for any assistance!

PS: is it correct there is no support for VBA in the EmbedCode function?

Best regards,

Wouter

Nice question. Here is a simple implementation on Excel.

Let's create some Cloud API using Wolfram Cloud (the same can be done from desktop version 10):

CloudDeploy[APIFunction[{"x" -> "Integer"}, Prime[#x ] &],Permissions->"Public"]

Save your Cloud Link, something like: "https://www.wolframcloud.com/objects/fc7dae07-d9a0-454f-a8d6-ab12bdbab2b3", to use in your VBA code.

Open Excel, go to VBA (ALT+F11), then create a new Module in your current file.

Then select your module, and create a function to call the information from your brand new Cloud Object as:

Function wolframPrime(x)

    Dim strURL As String
    strURL = "https://www.wolframcloud.com/objects/YourCloudLinkHere"&"?x=" & CStr(x)
    Set http = CreateObject("MSXML2.XMLHTTP")
        http.Open "GET", strURL, False
        http.setRequestHeader "If-Modified-Since", "Sat, 1 Jan 2000 00:00:00 GMT" 'prevent cached data
        http.Send
        wolframPrime = 1 * http.responseText
    Set http = Nothing

End Function

Now you can test your new function in Excel:

And get:

Don't forget that each time you use this function, you are consuming your Cloud Credit.

Very cool no?

PS: Unfortunately, the Community do not accept attachments in XLSM format. I created a example file with the embed code. Maybe moderators can change that?