Excel problem > A macro required... small one :)?

Question

I know it's very simple for you all :) but i couldn't find the reply.

The problem is : I have to retrieve data through one web query.. The query is : http://www.nseindia.com/marketinfo/fo/foquote_tab.jsp?key=OPTIDXNIFTY28AUG2008CE4500.0021AUG2008&symbol=NIFTY&flag=1

Now I have to run this query for 20 combinations . Like CE4500 can be CE4400; 21AUG2008 will change daily.

All I want that a macro who build the query syntax by picking these values from different cells. Like CE4400 from A1, date from B1 AND CE4500 from A2 and date from B2. I need a flexible reply so that I can customize the same in my way.

Answer 1

Hi

Microsoft has an article that explains how to build web queries that are based on parameters.  The link to it is in the sources below.

If this is enough to answer your question, then great!

If not post any follow-up questions. I'm not sure how good at coding you are. You could make a macro that reads the values of the cells and then turns those values into a web query that runs when you do something like click a button.

-Jim

Answer 2

Buddy, I will develop one macro for you. But the link you have provided in your question doesn't have any data. Hence provide me another, I'll make one macro for you!

Cheers!

Guru