Extracting value from internet gives Run-time error 19

[xprakash]

Hello guys,

I am trying to extract the family names of plants from http://www.theplantlist.org/ and put them in B column corresponding to the respective names of plants on column A. I tried writing VBA code but ended up getting "Run-time error- 91".
Note: I mistakenly wrote "Run-time error 19" as this Thread title!!
Would you please look up my code and correct if not write up so that desired result can be achieved?

Please Login or Register  to view this content.

Data format (problem):

column A . . . . . . . Column B
Musa
Triticum
Chrysanthemum
Jatropha
Oryza


Data format (expected solution):

column A . . . . . . . Column B
Musa . . . . . . . . . Musaceae
Triticum . . . . . . . Poaceae
Chrysanthemum . . Compositae
Jatropha . . . . . . . Euphorbiaceae
Oryza . . . . . . . . . Poaceae

Retrieving Data from internet.xlsm

[AB33]

The code works on the sample provided. Try it on the actual data and see if you get the result.

[xprakash]

Hi AB33,
Thank you for your help, but I am not sure if it is local problem on my PC- while executing the code in Module1, I still get the same error and when I click "debug", it highlights code

Please Login or Register  to view this content.

And while executing the code in Module11, it gives name for first occurrence and says "ERROR12031-".
Would you please guide me here? Should I have enabled some more tools among vba references?
Please check the tool references I enabled in this image file- VBA references.jpg
Or am I missing something else here?

[xprakash]

Found out the issue was with my IE setting. Once I ticked all "Use SSL" and "Use TSL" instances under "Advanced" tab in internet option, the code on module11 worked like a charm !
(the code on module1, however, does not seem to work but that does not matter now)
Thanks a ton AB33 !

[AB33]

Ah, the module1 code was your code. I tried to see if it works and did not . I have now have deleted that code. There is only one code with the attached. I have also attached it to your button. You need to test with more names and see if you get the result.

[xprakash]

Tested with larger data set and it gives data perfectly except for some exceptions like Amborella, Auxenochlorella etc. (not because of code fallacies but simply because searching those names would open different pages without class called "genuslist"). But their numbers were extremely few and were managed manually. Thank you again!