![]() Sub OpenCasNo(Vnumber As String, EmailSite As String) 'put 105-57-7 in a cell and stay on that cell when you Also, there are some cas numbers this database doesn't have, so it would after clicking on "search" it would open a web page but with no data and it would show the legend "No records found". So the issue here is that imagine do that manually, I would like that my excel file would take the data of the "cas number" for a row, and automatically be able to open thsi web page, fill the 3 cas number fields I told you and after that, obtain the data from the new page and copying it to excel, and then doing the same for the next row until it arrives to the 3100 item. and each one would be one column in my excel file. From that page I want to collect the Name, Latest JECFA evaluation, etc. After that if you click on the search button, another page will be opened with a lot of info. There, if you look at the bottom right of the page, you will see a field named "CAS number", there you have three fields where you have to fill the number I told you, in the first one "105" in the second "57" and in the last one "7". I have like 3100 rows with data like this, and what I want is to obtain more data to fill the rest of the columnsīy accessing the web page: /jecfa/flav_agents/flavag-q.jsp?language=en I am in an issue similar to xxxjjttxxx, I have an excel file that has many columns with data and one of those columns is named "cas" and is filled with numbers like "105-57-7" that is technical data. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |