scrapping from website

[Dipak543]

Hello friends,

I want to extract specific data (Table) from this website ( https://www.nseindia.com/option-chain ). I am attaching a photo for clarification.
Pls help me it urgent.

Thanks

 

[Worf]

I am getting this error; do you also get it?

 

[sandy666]

XL2007 does not support PQ

 

[Dipak543]

I am getting this error; do you also get it?

View attachment 18996

thanks for the reply... no, I didn't get that error but I resolved the problem..now i am able to scrap the data

 

[Dipak543]

XL2007 does not support PQ

View attachment 18997

yes, bro. I changed my office version from 2007 to office 365

 

[sandy666]

yes, bro. I changed my office version from 2007 to office 365

Thank you

btw. explain to others how you resolved the problem

 

[Dipak543]

Thank you

btw. explain to others how you resolved the problem

actually I followed a youtube video -

 

[sandy666]

Thank you for sharing

 

[Dipak543]

Thank you for sharing

thanks,
Can you help me on this prblm-

Code looping twice

Hi friends, I am stuck in a VBA problem. actually, the code is printing the value twice in subsequent rows its working fine on my previous excel version 2007 but now I shifted to office 365 and its printing the values twice whenever the cell changes. Attached photo for clarification see timing...

www.mrexcel.com

 

[sandy666]

Sorry mate, I am not vba wizard. I don't like vba