Blastroid

@bmetaylor said:

I am trying to use VBA to import data from the API into excel. I have written code to format the ULR. But i am not sure how to send the request from the code to the API. I would also like the take the xml response and extract the information I want (ID,name,release date) to cells in excel. I am super new to any of this so feel free to dumb it down (however any help would be appreciated). Here is my code so far:

Private Sub CommandButton1_Click()

Dim strInput As String

strInput = TextBox1.Text

strInput = Replace(strInput, " ", "%20")

Dim myURL As String

myURL = "http://api.giantbomb.com/search/?query=" & strInput & "&api_key=ABCDEFG123456&format=xml&resources=game&field_list=id,name,original_release_date"

End Sub

I have written a JavaScript function that will export a HTML table to Excel. It only works in IE of course but may help with your need. If you can get the API data to a HTML table and give the table and ID then after the API load call the function. I know it is not VBA but hope it helps.

 function F_table_to_excel(tableid){var mybrowser; mybrowser = navigator.appName; mybrowser = mybrowser.toUpperCase(); if (mybrowser.indexOf("MICROSOFT") != -1){ alert ("After clicking the [OK] button the table will be exported to Excel. You may notice the web browser appears to be locked up during this process. Excel will be shown once the process is complete. This may take several seconds or minutes depending on the amount of data."); var x; var i; var j; var tmps; x = document.getElementById(tableid).rows; var xls = new ActiveXObject("Excel.Application"); xls.visible = false; xls.Workbooks.Add; for (i = 0; i < x.length; i++){ var y = x[i].cells; for (j = 0; j < y.length; j++){ tmps = y[j].innerText; tmps = tmps.replace(String.fromCharCode(13), ""); if (tmps.length != 0){ if (tmps.indexOf("=") == 0){ tmps = " " + tmps; } } xls.Cells(i+1, j+1).Value = tmps; } } xls.visible = true; xls.WindowState = 3; xls.Application.AppActivate; } else { alert("This feature only functions with the Microsoft Internet Explorer web browser."); } }

@Ben_H said:

@Animasta said:

I love how, whenever there's a slow week, people create threads about it. Like come on guys sometimes there are slow weeks get over it gosh

Yup. Also, the idea of that CryBlock thing is intriguing.

Just finished version .01 of CryBot Chrome Extension:

http://dev101.info/crybot/crybot.zip

It does have a side effect when enabled to not allow quote/replying to a forum message as it alters the text on the page. Just for fun so enable it, test it, then disable it.

All you have to do is unzip the folder somewhere and in Chrome - Tools - Extension - Developer Mode - Load the unpacked extension - then refresh this post.

What it does: Replace crying text with [Replaced by CRYBOT] in red. You can mouse over the text to see what it replaced. Only created short list as this is the first every extension I have ever coded.

They have a coming soon section also we have the ability on any internet device to see if new content exists or not. I am sure if they provided us even more communication it would still not stop such posts.

@murisan said:

@Blastroid said:

@murisan said:

@Blastroid said:

No ads

If that was all I wanted, I'd just turn on adblockplus.

Do they make cryblock?

[THIS COMMENT HAS BEEN REMOVED BY CRYBLOCK®]

Cool it worked

@murisan said:

@Blastroid said:

No ads

If that was all I wanted, I'd just turn on adblockplus.

Do they make cryblock?

No ads

Camera quality looks good. I do recommend not pointing the camera at the sun and don't video blog about video blogging.

So you have been milking the system for 2 years? You sure your not in the U.S.? :)

Crap her project funding has ended? How do I send her money?