How to create a data form in excel in 2003
HOW TO CREATE A DATA FORM IN EXCEL IN 2003 CODE
Replace xxxxxxxx in your code with your form's respective numbers.
You will need these numbers for each field. Look for the entry.123456789 for each of the fields. Note a “?” is required at the end of the url.Īlso under headers find “Form Data”.
HOW TO CREATE A DATA FORM IN EXCEL IN 2003 HOW TO
This is an ASP example of how to use that OAuth library again since both the ASP and the VBA are using the VBScript syntax, it could probably be adapted. You should be able to adapt this OAuth 2.0 ASP library for your VBA code. In your VBA, you essentially use the following to send XML requests: Dim x as MSXML2.XMLHTTP You can play with the OAuth requests here, which should help you get started.ĪPI functions are called by GET/POST requests with XML, which you can call using the XMLHTTP object.įirst, reference Microsoft XML in your Excel project (Tools->References->Microsoft XML, v6.0) The OAuth 2.0 link that the spreadsheet docs refer to is out-of-date. In that light, here is my original answer, if it helps. The ASP OAuth below is probably usable with some work, but I noticed it uses Session variables and some other ASP objects, so you'd have to do a lot of tweaking. The reason this is non-trivial is the authentication part. I think it would be a lot easier if you could make your Google spreadsheet public, but I doubt that is advisable with sales data. I had started answering your question, but realized that it was much less trivial than I thought it was when I started playing with the OAuth 2.0 API. HttpRequest.Send "entry.0.single=" + column1 + "&entry.1.single=" + column2 + "&pageNumber=0&backupCache&submit=Submit" tRequestHeader "Content-Type", "application/x-www-form-urlencoded" Replace column1 with your desired values. Add a reference to "Microsoft XML, v3.0" before. Next we try to execute the form POST from our Excel sheet via the following code.
You can test the entry now with curl if you have it on your system (replace the formkey placeholder with the formkey from your table): curl.exe -v -k "" -d "entry.0.single=test&entry.1.single=test2&pageNumber=0&backupCache=&submit=Submit"