Vba getelementsbytagname. getElementsByClassName("leftalign floatleft")(0) Debug. HTMLソースをみて、. Dim xmlSourceList As Object. I wrote similar code that works with web pages (not API) but in this example it breaks and don't understand why. To use the following example, just copy/paste it into a new file saved with the . Basically, in the HTML doc I want to search out the 13th "label" tag and check if it matches the cell value in the excel doc. Oct 8, 2013 · Use document. I referenced the Microsoft XML, v2. The extracted . Length Jul 9, 2013 · I'm trying to develop a VBA script that takes the ISSN number of journal titles from an excel 2010 spreadsheet, and query the Sherpa/Romeo web service (a copyright policy database). 반환된 HTMLCollection 은 살아있는데, 이는 document. Feb 10, 2019 · Dim elements As IHTMLElementCollection. 今回は、取得したIEからDOMを取得し、さらにそれぞれの要素を取得したいと思います。. BSTR that specifies the name of an element. Navigate "<web site url>" While IE. getElement*, querySelector*와 같은 메서드를 사용하여 DOM에서 원하는 요소를 쉽게 찾을 수 있습니다. Standards information. getElementsByTagName() not returning elements. 다양한 예제와 설명을 통해 JavaScript의 요소 검색 기능을 마스터할 수 있습니다. 'This Must go at the top of your module. Code: Sub Extract_TD_Text() Dim URL As String. えーっと、私もあんまり詳しいわけじゃないですが Sep 20, 2015 · @TimWilliams Hi Tim, thanks for your answer but sorry it is just a typo. ID = "url" Then MyVar = TDelement. Apr 11, 2018 · Codify Academy, getElementsByClassName() and getElementsByTagName() methods Oct 27, 2016 · The getElementsByTagName method simulates the matching of the provided argument against the result of the tagName property of IXMLDOMElement. Set HTTP response to our HTML object. ということです。. Wait Now + TimeValue("00:00:02") '~~> give another 2 seconds. When you than delete such a node, only the opening tag Aug 13, 2015 · 続・Microsoft Edgeを操作するVBAマクロ (DOM編) 以前VBAからMicrosoft Edgeを操作するマクロについて記事を書きました。. innerText The above code gives me Phd as the output. ReDim Preserve oTemp(1 To UBound(oTemp) - 1) getElementsByAttribute = oTemp. getTextContent(); This should give me something like: Name | Number A | B | C | 001 But I get: Name | Number A | 001 B | 001 C | 001 So, I think the getElementsByTagName("Number") is looking for number node in all the children of a node. 1. My code (borrowed from an online tutorial) is: Private Sub Worksheet_Change(ByVal Target As Range) If Target. getElementsByTagName is not finding "Input" or "td" tag with ID in it. 0. IE is no longer a dedicated browser on Windows, so may not fully support automation going forward with Windows 10. Sep 11, 2022 · Steps. Here is a short example: Here is a short example: vArr = Array("element 1", "element 2", "element 3") Debug. getElementsByTagName("a") Debug. Let's move further and see how we assign internet explorer document object Apr 19, 2023 · Dim IE As InternetExplorerMedium Set IE = New InternetExplorerMedium For Each ele In IE. getElementsByTagName(v); Parameters. 6. JavaScript에서 요소를 검색하는 방법을 배우고 싶다면, 이 문서를 읽어보세요. EDIT: To find if a p element has the content class, instead of getElementsByClassName (), you could use. May 22, 2016 · In the code below, i'm using getElementsByClassName in VBA to get innerHTML from elements: Mar 4, 2013 · This is an example I made for an answer, it works but I had planned on accessing the child nodes using getElementByTagName but I could not figure out how to use them! The HTMLElement object does not have those methods. getElementsByTagName("p") will start at 0. という声が聞こえたり、聞こえなかったり･･････。. Jun 6, 2019 · You first need to go to the collection where the classname is "search-results organic" and in there find all the "info" classes. Busy DoEvents Wend set document = IE. xmlDocument. getElementsByTagName("table")(0). getElementsByTagName("table") Dim k As Integer. XMLDOM") xmlDoc. With your example: txt = ie. print Doc. Dec 31, 2019 · 今回はExcel VBAマクロ。. VBA - Can't get Element by Tag Name. My issue is that the method I'm using to find the text - looping through . Application. Jul 21, 2019 · 1. Row And _. I would like to navigate to a webpage, find specific text, then return that text to excel. Then, using SelectNodes method over getElementsByTagName since you will need to reference the second defined prefix as HourlySchedule is a child of Query node, you can then query to the needed element: Sep 7, 2015 · I don't know if this is due to the method I'm using to parse my XML file. oXML. Public Sub getTitleElement() Dim myElement As Object. using Thanks for the pointers. This means that you need an extra collection variable: Set HTML = IE. (. O propósito desse método é selecion May 14, 2017 · Loop. send. NodeName should return "tag" in your case. The following example creates a XmlDocument object and uses the GetElementsByTagName method and the resulting XmlNodeList object to display all the book titles. La méthode Element. Dec 26, 2016 · This function returns the very first element with given class name in the DOM document and Nothing when no element with this class name exist in the DOM document. IEのタグネームクリックと値を入力するマクロ. If there was an id then I could use getElementByID but sometimes there is no id. However, this code seems to do nothing. getElementsByTagName("a")(0). getElementsByTagName() を再度呼び出さなくても DOM ツリーと同期を取り続ける Jul 19, 2019 · For Each para In paras. VBA getelementsbyclassname use with getelementsbyid. href next i This gets the first <A> tag from each H3. Set tbls = ie. getElementsByTagName() 을 다시 You can further automate this process by writing a simple macro using VBA. NET関連だからわりと簡単だろうと思いきや. Also, the way you're using Split() isn't making sense to me. innerHTML is left empty. innerText("Value") End if Next The thing is that I can't make the code to go into the If statement. I don't know, whether this is the best approach to the problem or not, but here is how I got it to work. The code is as follows: Code: Sub Getalllinks_tescos() Feb 13, 2016 · My company is needing to reset usernames and passwords for over 1000 people and instead of doing it emanually, i would like to have VBA automate it for me. Something like this should work, I'm assuming you already have a pointer to the IE or Document Object. getElementsByTagName("p") retrieves a DispHTMLElementCollection object but not an array. Sep 13, 2006 · End With[/vba] All in all, here is the whole sub, you can choose which of the navigate blocks you want to use (which page you want to use):[vba]Sub IE_login() Dim ie As InternetExplorer Dim C Dim ULogin As Boolean, ieForm Dim aid As String, cu As String, pw As String redo: aid = Application. 値入力やクリックなどIEを自動制御. 'Here is where I want code to find specific child node. 3. 6 dll in my VBA, and then the following code snippet, gives me the required values . Print v(1) Mar 13, 2011 · Hey Internet, I'm messing around with some Internet Explorer automation. async = False. However, I will not know the total spans beforehand and so I cannot simply give span(0) and span(1) in my code. ie. Depending on the HTML tree, you'll need to change which elements you zero in on in the sub, obviously. Jan 12, 2017 · This is the VBA code that I've got so far: Set TDelements = HTMLdoc. yahoo. This process is popularly known by the term Screen Scraping. I have it connect to the IE window fine but the getElementsByTagName ("input") only returns the last input tag. 5. </button> <br /> <button onclick="div1ParaElems();">. On the webpage here is the tag. Dim wMatrix As String. Row = Range("GolfLinkNumber"). C#. La liste retournée est live, c'est à dire qu'elle se met à jour automatiquement à chaque changement de l'arbre DOM. However, when the HTML has more than one attribute within the class containing the price, the previous code is unable to retrieve the information. May 14, 2013 · VBA Excel: Loop through XML Attributes Hot Network Questions linkedin job post "product tester' recieved a email check PDF to deposit so I can purchase the product which I am supposed to test. XMLDOM" instead. getElementsByClassName("search-results organic") Mar 25, 2015 · W3C reference : "The getElementsByClassName () method returns a collection of an element's child elements with the specified class name". Dec 1, 2016 · In VBA the appended (0) refers to the first element of an array (assuming an Option Base 0). v [in] Type: BSTR. getElementsByClassName("fpStriked fpStrikedBefore jsStriked"). Aug 3, 2017 · Here is a small chunk of the VBA, it does everything I need except for the last (most important) step which is to tell me whether or not a specific value exists within the HTML. BO in excel vba using following code but it doesn't seem to work. k = 0. getElementsByTagName("span")(1) is attempting to return an array of elements where there is only 1 and thus the only returnable value of that array would be located in the first spot of the array htmlEle. innerText after that I would like to split the table inside excel cel Feb 8, 2018 · Here is my code Sub loadrss() Dim http As Object, html As New HTMLDocument, topics As Object, titleElem As Object, topic As HTMLHtmlElement, i As Integer Set http = CreateObject("MSXML2. Set ie = Nothing. getElementsByTagName は Document インターフェイスのメソッドで、指定されたタグ名を持つ要素の HTMLCollection を返します。ルートノードを含めた文書全体が検索されます。返された HTMLCollection は生きたものであり、つまり document. It's worth noting that you'd need to use brackets around that :not [height], too, otherwise your selector isn't valid: 1. dim i as long for i=0 to Doc. HasChildNodes Then. Visible = True . 1 Web scraping with getElementsByTagName() 0 VBA - Macro do not find Table with GetElementByTagName . Document Object Model (DOM) Level 2 HTML Specification, Section 1. 記事を書いたときは、getElementByIdメソッドが使えたので「普通に May 5, 2014 · The following macro works just fine. Hello, I am trying to acquaint myself with VBA's getElementsByTagName, but I am struggling to make it work for me. getElementsByTagName("h3"). getElementsByTagName("tr") Debug. コピー. Consider using the MSXML's IXMLHTTPRequest object for web server requests. . Web Scraping: innertext. getElementsByTagName("h3")(i). You need to create a HTMLDocument object from the response and use it for the parsing. Item(0). You should create the array looping through collection. However, now that I have had to turn these into MSXML2. getElementsByTagName("section") Debug. If eventNode. Aug 19, 2020 · In general the following code works fine (example): price = html. I don't want that. を示した。. Print elements. Dim xmlDoc As Object. document. write(HTML) DOMObj := HTMLFileObj. Type Dim getElementsByTagName, hit ENTER, then delete that declaration: poof, fixed. innerText. which will return true if the element has the class. #1. I'd like this to focus just on one section of the webpage, Div Class: Div Class: product-list-container. I wrote the following code in order to retrieve data from an API and hopefully get the content of a specific element. Aug 31, 2013 · Hello, I am trying to acquaint myself with VBA's getElementsByTagName, but I am struggling to make it work for me. Print ele. – Mathieu Guindon. Item (1). Column Then. Application") With IE . 2. innerhtml Jan 11, 2019 · It's possible that htmlEle. getElementsByTagName("section") msgbox DOMObj[0]. When executed, it does not recognize or support namespaces. Document. g. Aug 23, 2019 · So I have some code which pulls URLs from URLs by tagname if it contains the If Instr in the code below. basが入っていますので、これをVBAのプロジェクトに追加すればOKです。 Nov 10, 2014 · VBA . ここで一つ気になったのがコイツ↓は一体何なのか？. com/quotes/ADANIENT. DOMDOCUMENT60 objects (because Exc Jan 10, 2017 · Set LH = Doc. InputBox("Please enter aid", "enter aid", Default:="3") Dec 9, 2006 · the tagname of the 1st node is 'tag', the following command should return just that first node. ・どれを使うべきかわからない。. Column = Range("GolfLinkNumber"). HTMLObj := ComObject("HTMLfile") HTMLObj. (note the index at the end?) There is no (that i could find) "sibling" feature of the InternetExplorer object in VBA, so you'd have to do it Sep 10, 2018 · The getElementsByTagName collection is zero-based but the . Mar 14, 2016 · To get an element with the class name, I would use querySelector: Set element = ie. Next. Dim MyRequest As Object. Title. Print element. Dim strWeb As String, myFile As String. Nov 28, 2017 · I can do getelementsbytagname by doing ("div") and listing its item number but I wanted to get to the class name item 2 in this instance. For Each eventNode In lvl2. Target. ScreenUpdating = False Set IE = CreateObject("InternetExplorer. Xml; public class Sample1. 遷移したら お決まりのコード を入れて、ページが読み込み終わるまで Dec 22, 2014 · When using getElementsByTagName, getElementsByClassName, etc. End Function. 루트 노드를 포함해 전체 다큐먼트를 대상으로 검색됩니다. In the following code, I am trying to grab the birthdate and place it in cell A1. Read more about HTTP requests here – Http requests in Excel VBA. getElementsByTagNameNS method is used. For Each tbl In tbls '~~> looping in order to find the exact table. I have successfully collected data from other sites such as ladbrokes using this method however not with this site. Instead, you should use the selectNodes method, which is faster in some cases and can support more complex searches. using System; using System. Application") IE. Next i. getElementsByTagName don't catch TDelements from the web table, and I can't figure out why . querySelector("[class='" & className & "']") Sep 17, 2021 · Open URL and Enter Data in Form Using VBA. Length (the # of H3's, called Count in other methods) is one-based. I'd like this to focus just on one section of the webpage, Div Class: Div Class: product-list-container and exclude: Div Class: recommender__wrapper The code is as follows: Sub Get all elements with the tag name "li": Get all elements in the document: Change the inner HTML of the first <p> element in the document: document. Set myElement = IE. Here's the portion of the VBA Mar 11, 2024 · Note that when the node on which getElementsByTagName is invoked is not the document node, in fact the element. classname") Debug. 5; Remarks Nov 12, 2013 · String number = eElement. Quit. Element. 0 Beta1 (i assume VBA script as well) getElementsByTagName() only shows opening tag for HTML5 tags section and nav however works with all other HTML4 tags. getElementsByTagName("span") (0). 要素の特定をするために、object. Aug 16, 2018 · VBAでIEを操る（起動済みIEをシェルとして…. Jul 21, 2021 · I see there's only 1 element with name attribute as "matbr" so you can try iframeDoc. The example here shows how to extract or read the contents inside an HTML element (any element) from Excel using a simple macro. Raymond Wu - I try it before I wrote here, but doesn't work. document with document . Excel VBAを使ってxmlファイルを読み込む方法は. innerHTML = "Hello World!"; More examples below. innerhtml, "Resolver") > 0 Then Debug. getElementsByTagName("tr")(0) will return the first (singular) IHTMLElement from the collection. May 2, 2017 · Element retVal = object. value="test" end with End Sub VBA getelementsbytagname issue. getElementsByTagName("div") For Each TDelement In TDelements If TDelement. Reference. If document is Object, declare a local variable for IE. openedpage = iedoc1. I am a beginner to web scraping with excel vba and need some help. Dim Search As String. Oct 9, 2013 · document. Dim toTranslate As String. ReportFilename = "C:\Temp\Report1. Dim obj As Object. Here is an example of class containing multiple Sep 19, 2019 · I've seen this manner of excel VBA before, but unfortunately, it doesn't seem to work for me. With modern browsers it is a faster method for matching on elements. getElementsByTagName () retourne une liste des éléments portant le nom de balise donné. GetElementById in VBA. This is something you'd use document. I'm using Excel 2016, and I'm trying to navigate to an internal website and click on a link to start downloading a file and save it out to my desktop, but unfortunately, the code that I've seen that "clicks" the link doesn't seem to work. public static void Main() {. Print TableRows. I use Microsoft Office 2013, and have enabled Microsoft Internet Control and Microsoft HTML Object Library. Public Function getElementByClassName(doc As MSHTML. Set para = para. Oct 27, 2016 · The getElementsByTagName method simulates the matching of the provided argument against the result of the tagName property of IXMLDOMElement. xml". GetElementsByTagName("table Feb 24, 2019 · Try the following workaround which uses css selector syntax to select by class. getElementsByTagName() メソッドは、生きた HTMLCollection で指定されたタグ名を持つ要素を返します。 この要素のすべての子孫が検索されますが、要素そのものは検索されません。返されるリストは生きており、 DOM ツリーとともに自動的に更新されます。 Mar 16, 2022 · VBA. GetElementsByTagName ("*"). inputタグが使えなさそうな場合は別の方法を Jul 29, 2021 · VBA . '~~> Be aware that the table's class value has one white space at the end. highlighted_message"). document, using the correct type - you'll get intellisense for its members then. Mar 23, 2018 · But when you read a HTMLDocument with Angular tag names such as article or main or any other non-standard html tag names, getElementsByTagName () fails to read the DOM correctly. Print myElement. Print "OK": Exit For next For Each ele In IE. For the site I used in testing, this structure worked flawlessly. Also, you might want to look into the thread on XML parsing in the Other forum on this board. For example, you can extract news headlines from a news portal, or get stock quotes from a web page etc. . Load 7 more Mar 22, 2013 · 4. Visible = True IE. Dim Req As Object, xmlobj As Object. May 24, 2020 · That while the data are showing in a visual browser as You can see in the image below. getElementById("profile-education"). So I have some code which pulls URLs from URLs by tagname if it contains the If Instr in the code below. How to get the attribute value of the tag by attribute name with HTMLDocument object in VBA? 0. getElementsByTagName ()などを使いますが、. DOMって何？. innerhtml If InStr(ele. getElementsByClassName("textoblanco") Debug. Only getElementById returns a single element whereas the rest of them returns a collection of elements. 'Assuming you already have IE object/Document. Dim oRow As Object, oCell As Object. I did tried getElementsByTagName, as well as getElementsByClassName("news"), they did not work, a solution may be get the attribute "href" after getting the TagName"a", since the "href" is one of the attributes of tag "a". Using getElementsByClassName in Excel VBA. xmlDoc = CreateObject("microsoft. Length. document. Jan 30, 2012 · Re: VBA - Finding Multiple Values with IHTMLElementCollection / GetElementsByTagName Bump to get some advice or direction on this, any more information I can provide? Unfortunately the code excerpts are too large to extract from the otherwise sensitive nature of the script. xhtml extension. May 27, 2017 · As a result, in VBA declare such namespaces by designating user-defined prefixes, here doc and doc2 is used. Stan. したい場合に使う。. ChildNodes. LoadXML objHTTP. Open "GET", strPath, False. LoadXML . ・そもそもどのような種類があるのかわからない。. Loop through each topic, parse each topic’s title, link, upvotes and username using different methods. MSHTML. querySelector(". Navigate "URL" While IE. tech. VisibleをTrueにしてIEを表示、Navigateで好きなページへ遷移する、といった手順を踏みます。. Dec 20, 2015 · 2. Set elements = html. getElementsByTagName("p") [0]. Dec 22, 2017 · Capitalization makes no difference, VBA is case-insensitive. Set getElementByClassName = doc. Also, the collection returned by para. querySelectorAll () for. It then populat Jan 15, 2022 · VBA・WebDriver間の通信はJSONでのやりとりになりますので、JSONエンコード・デコードのためのライブラリを入手します。以下から「Source code」をダウンロードして解凍するとJsonConverter. DOMDOCUMENT objects. getElementsByName("ElementName")(0). Updated code: Dim ReportFilename As String. and exclude: Div Class: recommender__wrapper. Set OrganicLinks = HTML. finance. 読んで字のごとく、タグ名からElement（要素）を取得するメソッドです。. Nov 13, 2020 · getElementsByTagNameとは. getElementsByTagName () Document 인터페이스의 getElementsByTagName 메소드는 엘리먼트의 HTMLCollection 과 주어진 태그명을 반환합니다. IE制御はinputタグ以外にもいろいろ方法がある。. Dim IE As InternetExplorer. item(0). First, we pull Hacker News homepage by making a basic HTTP GET request. getElementsByTagName("span")(0). getElementsByTagName("p")(i) In the above, para is your loop variable. getElementsByTagName("td") For Each tdObj in td. innerHTML. AutoHotkey Code. IHTMLElementCollection) of objects, even if that collection contains only one or even none. responseText Dim i As Integer Dim list As IXMLDOMNodeList Set list = xDoc Jun 9, 2014 · I am a HTML novice and this project has clearly identified that, but I'm sure that someone in this community has the answer. Option Explicit Dim IE as Object Sub YSF_automation() Application. Instead you should use the selectNodes method, which is faster in some cases and can support more complex searches. outerHTML. Try something like the following: Dim url As String. XML DOM getElementsByTagName () 方法 Element 对象 定义和用法 getElementsByTagName () 方法返回带有指定名称的所有元素的 NodeList。 语法 getElementsByTagName (name) 参数 描述 name 字符串，规定要搜索的标签名。值 '*' 匹配所有的标签。 实例 下面的代码片段使用 . Scam? Nov 19, 2019 · Try to use the following code: Sub Test() Dim IE As Object Dim startDateText As Object, endDateText As Object Set IE = CreateObject("InternetExplorer. Jun 14, 2013 · Hi I am importing a whole table from a website to excel string: Dim fST As String fST = Doc. getElementsByTagName("tr") this will return all tr elements inside the "document" element. I am trying to reference an element. As annotated in the code, it is necessary to use early binding to use the method getElementsByClassName . What this macro will do? Using the script (below), you can extract specific contents from any websites or a webpage. getElementsByTagName("number"). Web Scraping Elements By Class & Tag name. Code: Sub test() Dim oDom As Object: Set oDom = CreateObject("htmlFile") Dim x As Long, y As Long. Web scraping with getElementsByTagName() 1. If you've set tr with the getElementsByTagName function, then you'll need to iterate through each tr object to get the child td objects (or you can just reference a single one): Set td = trObj. May 17, 2019 · getElementsbyTagNameなどgetElementsの種類を確認. Contents in webpage, are embeded inside HTML elements. Getting the html "id" tag in excel vba. It looks like ID is not a property of the TDelement. If txt = "No tasks have been defined. where the word Elements is plural, you are returning a collection (e. outerHTML of the extracted node only containes the opening tag and the . HTMLDocument, className As String) As IHTMLElement. Show all p elements in document. Dec 5, 2020 · 1. Set TableRows = IE. getElementsByTagName - doesn't appear to be returning all Jul 24, 2020 · I have a piece of VBA code that worked perfectly in an older environment, using MSXML2. value="test" end with End Sub Nesse video você vai conhecer o método getElementsByTagName do objeto DOCUMENT do DOM ( Modelo de Objeto de Documentos ). C#でxmlファイルの読み込みはやったことがあるのですが、. La recherche porte sur le sous-arbre de l'élément spécifié, à l'exception de cet élément lui-même. Yeah, I think that getElementsByTagName literally just looks for tags and not classes. Excel 與 VBA 財務應用初階班 第 11 課 Loop '將第二個 table 讀取出來，存入 myTable 變數 Set myTable = IE. length - 1 debug. 'do something with each td object'. responseText. It's used to set IE as the active window Public Declare Function SetForegroundWindow Lib "user32" (ByVal HWND As Long) As Long Sub Automate_IE_Enter_Data() 'This will load a webpage in IE Dim i As Long Dim URL As String Dim IE As Object Dim objElement As Object Jul 14, 2015 · VBA Code. ' READ HTML PAGE. For Each lvl2 In lvl1. Dim data. ReadyState <> 4 DoEvents Wend 'find all of the tr. 知らなかったので調べて試してみつつ記事にしました。. Oct 27, 2016 · ReDim Preserve oTemp(1 To UBound(oTemp) + 1) End If. 検索するとgetElements がいっぱいあり、. In last video, we have learnt different type of web elements on a web application. It opens an instance of IE and uses the "getelementsbyclassname" method to return the expected value for "my_rate". {. How your code would work is if you indexed into initial collection returned by getElementsByClassName and then chain on getElementsByTagName, and use that VBA . あまり記事が見つからず少し大変でした Sep 19, 2016 · 0. Value. Document. IE操作の自動化でHTMLドキュメント内の指定したタグ名の要素オブジェクトを取得する方法を解説します。GetElementsByTagNameメソッドの使い方と例を紹介し、外部リンクや関連記事も掲載しています。 Aug 23, 2019 · Aug 23, 2019. Feb 11, 2020 · Try the below . Using AhtuHotkey 2. Sub parseXML() Dim xmldoc As Object. " Then. When you than delete such a node, only the opening tag May 7, 2019 · If that does not fix the error, try to change the type of Object you're creating and use "microsoft. querySelectorAll. getElementsByName("matbr")(0). Dim xDoc As DOMDocument Set xDoc = New DOMDocument xDoc. という Oct 14, 2015 · エクセルVBAでIEを操作する初心者向けのシリーズの6回目です。今回はタグ名で要素をゴソっと取得するgetElementsByTagNameの使い方です。様々なHTML要素を簡単に取得できます。 Aug 4, 2017 · I've been playing around with some VBA for a while now, trying to check a specific instance of a tag name in an HTML document against an user inputted value. Value = Range("a2"). I could use May 14, 2017 · I am trying to get data from https://in. However when I run the second macro which Nov 16, 2016 · i found this vba script which works super fast, however it only works if there is only 1 table on the website. zwuqpciwhpntznwevqmw
Scholarships Portal