Write an excel macro to fetch info

Need to scrap DELL warranty info using the below api from dell. Excel Macro that can look at a list of Service Tags in a column in Excel and then return the relevant warranty information in the columns next to it. Relevant DELL Warranty Status API - [login to view URL] List of Service Tags in Column A Warranty Product Name in Column B Warranty Period in Column C I have the attached VBA code to pull DELL (Dell laptops / desktops / servers) warranty information. But its not working in my excel 2010, its not returning any result. Hence could you please help me to make it work.