Programming

Help with api to excel?
Hi everyone I�m hoping one of you guys can assist. I�m not a programmer but kind of know what I want to do. In short I want to run an api into erepublik.com and save the data in an excel spreadsheet. The api is this one..... api.erepublik.com/v1/feed/exchange/RUB/RON/feed and the 10 returned records in xm... 18 Jan 2010 10:53

can anybody send me complete list of MS Office Object model ?
please reply back at gadiyaabhay.ca(a)gmail.com ... 17 Jan 2010 08:21

search text files for a certain word
How do I search text files for a certain word using a macro. I need to look for the word "SerialNo" and return the following 10 characters. I will be repeating this for hundreds of files. For now, how do I do it for a single file. Excel 97 ... 22 Jan 2010 01:51

Insert a square in a cell with VBA
Hi I have a list in Excel 2007. I want to put a square to the right of some of the list items. How can I do this with VBA. The end user will see the list on a printout with square/checkbox in the right column. The idea is that the end user should go thrue the list and mark/check the items that he agrees on ... 17 Jan 2010 05:07

Remove Duplicate Numbers in One Cell
My worksheet has one column in which each cell has one and two-digit numbers separated by spaces, such as 1 18 22 5 1 31 8 11 6 1 I want to remove all the duplicate numbers in each cell, leaving only one instance of each number in there. (1 and 11 are different numbers, of course). I've tried a few solutions... 16 Jan 2010 09:31

Setting workbooks
I have some code that includes the line: Set shRanks = Workbooks("Ranks.csv").Sheets("Ranks") The problem is that the file I need to set as shRanks may have an integer in its name - eg "Ranks17.csv" How best can I do this? ... 17 Jan 2010 05:07

Access Version being used
This work only if the version of Access matches the version of Excel. How do you detect the Access version being used? Private Sub CommandButton5_Click() 'Go to customer database Dim X As String Dim nVer As Long nVer = Val(Application.Version) MainMenu.Hide If nVer = 11 Then X = Shell("C:... 16 Jan 2010 05:11

MRP Excel Spread sheet
Hi I am looking to download an excel spreadsheet mrp production scheduling system / format. Can anybody help me. Tx JJ ... 16 Jan 2010 04:07

Disabling all pushbuttons
I added one pushbutton on top of my Sheet1. I then right-clicked that button and selected "Copy. Next, I pasted multiple instances of that same button on Sheet1 up to Sheet12. So, basically, I have many instances of the same button scattered through sheets 1 to 12. What is a good way to disable (and enable)... 16 Jan 2010 08:25

Frastrating-doesn't give all the data
in the example code below, why doesn't it return the whole source of the webpage Function Get_Webpage(my_url As String) As Variant Set my_obj = CreateObject("MSXML2.XMLHTTP") my_obj.Open "GET", my_url, False my_obj.Send Get_Webpage = my_obj.responsetext Set my_obj = Nothing End Function Sub test() Dim ... 16 Jan 2010 08:25