![]() Set elements = HTML.getElementsByID(“detail_topsection”)Įnter code hereerow = Sheet1.Cells(unt, 1).End(xlUp).Offset(1, 0).RowĬells(erow, 1) = HTML.getElementsByTagName(“span”)(10).innerTextĬenter code hereells(erow, 1) = HTML.getElementsByTagName(“span”)(14). ![]() If InStr(ele.innerText, "Details") > 0 Then ele.Click Cage Code 98376 was last updated on with the following company details. Star Cases, Llc has a registered CAGE Code for doing business with the United States government. The addresses of the facilities associated with the two CAGE Codes were different as well. However, in its cover letter, BDO USA identified a different CAGE Code, 6YTU0, and listed this CAGE Code on its DD 254. The CAGE Code is pulled from SAM based on DUNS selected on the action. STAR CASES, LLC ZERO MANUFACTURING CAGE CODE 98376. The CAGE Code corresponding to the FSS Contract was 32ZC7. Set ie = CreateObject("INTERNETEXPLORER.APPLICATION")įor Each ele In ie.document.getElementsByTagName("a") See Data Dictionary Element 1D Use Case for appropriate data entry requirements. Note the code doesn't work unless you've already opened the website before and haven't closed the broswer (you need to accept the terms and conditions). I keep on getting an error for the below and I can't figure out why. that wish to pursue contracts or grants from the United States federal government. CAGE codes are assigned to businesses, organizations, etc. I'm starting by trying to retrieve it for one item, then eventually looping it. A CAGE code is a five-character alpha-numeric, unique identifier assigned by the Defense Logistics Agency (DLA). I need to retrieve the attributes for roughly 500 CAGE codes from the DLA and record them in my spreadsheet.
0 Comments
Leave a Reply. |