Amazon rankdata for titles in excel

Two years a go we had a spreadsheet developed where in column 1 we filled a keyword in that had to be in the title of the book (for instance: barack obama) , in row two of column one something else (hillary clinton for instance) ...etc...ran the macro, and amazon would return with the total number of finds in column 2 (975 for obama, 218 for clinton today) and the sales rank of the first item in column 3 (6 for obama, 50653 for clinton). Unfortunately the macro does not work anymore - I'm looking for someone who can either fix it, or has an easier better solution