Hi...
I have few web address from which i need to extract certain data's..
but this address keeps changing
For Ex: http://www.mrexcel.com/XXXX/newthread.
those "XXXX" are the things that keeps changing.
Is there anyway that i can put all address in first sheet of a excel file and on clicking the the address it should open as Web Query in a specified sheets, like this example
1. http://www.mrexcel.com/ABCD/newthread - need to open in sheet3
2. http://www.mrexcel.com/EFGH/newthread - need to open in sheet4
3. http://www.mrexcel.com/WXYZ/newthread - need to open in sheet5.
Can anyone please help me in this.
Regards,
Avinash
I have few web address from which i need to extract certain data's..
but this address keeps changing
For Ex: http://www.mrexcel.com/XXXX/newthread.
those "XXXX" are the things that keeps changing.
Is there anyway that i can put all address in first sheet of a excel file and on clicking the the address it should open as Web Query in a specified sheets, like this example
1. http://www.mrexcel.com/ABCD/newthread - need to open in sheet3
2. http://www.mrexcel.com/EFGH/newthread - need to open in sheet4
3. http://www.mrexcel.com/WXYZ/newthread - need to open in sheet5.
Can anyone please help me in this.
Regards,
Avinash