[Solved] How do I use VBA to send cell contents to be used as a PHP variable in a Facebook Graph API call?

by


You could use a VBA macro like I created below. In my example I made the macro tied to a button click

Sub Button1_Click()
    Set objHTTP = CreateObject("MSXML2.ServerXMLHTTP")
   URL = "http://www.yourdomain.com/page.php?variable=" & ActiveWorkbook.Worksheets(1).Range("A1").Value
   objHTTP.Open "GET", URL, False
   objHTTP.setRequestHeader "User-Agent", "Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0)"
   objHTTP.send ("")


End Sub

Your PHP script on your server would look like

<?php

$excelCellA1Value = $_GET["variable"];

//Work magic here such as posting to Facebook API

//TO DO: Profit!


?>

5

solved How do I use VBA to send cell contents to be used as a PHP variable in a Facebook Graph API call?