Power Query editor OR VBA to extract data from Grants.gov

Jagadeshrao

New Member
Joined
Sep 25, 2023
Messages
5
Office Version
  1. 365
Platform
  1. Windows
i have urls from which i want to extract data in to text format, i don't know if the webpage is html format or anyother format, URLs are in column A starting from cell A2, i want the text format of the webpage to be extracted and pasted in column B starting from cell B2
URL
General Information
Eligibility
Additional Information
Document Type:Grants Notice
Funding Opportunity Number:PDS-ASHGABAT-AW-FY24-009
Funding Opportunity Title:Alumni Small Grants (ASG)
Opportunity Category:Discretionary
Opportunity Category Explanation:
Funding Instrument Type:Other
Category of Funding Activity:Other (see text field entitled "Explanation of Other Category of Funding Activity" for clarification)
Category Explanation:Public Diplomacy
Expected Number of Awards:10
CFDA Number(s):19.900 -- AEECA/ESF PD Programs
Cost Sharing or Matching Requirement:No
Version:Synopsis 3
Posted Date:Jul 15, 2024
Last Updated Date:Jul 15, 2024
Original Closing Date for Applications:Aug 18, 2024
Current Closing Date for Applications:Aug 20, 2024
Archive Date:Sep 17, 2024
Estimated Total Program Funding:
Award Ceiling:$15,000
Award Floor:$5,000
Eligible Applicants:Others (see text field entitled "Additional Information on Eligibility" for clarification)
Additional Information on Eligibility:Eligible applicants are alumni or teams (as described below under point 1) that include at least one alumnus among their members. Definition of Alumni: citizens of Turkmenistan who have participated in the U.S. government funded/sponsored programs. 1. Please note that in Turkmenistan, grants can be issued only to registered individual entrepreneurs, registered profit or non-profit organizations, registered non-government organizations (NGOs) and/or registered Economic Societies.
Agency Name:U.S. Mission to Turkmenistan
Description:
The U.S. Embassy in Ashgabat’s Public Diplomacy Section (PDS) of the U.S. Department of State is pleased to announce the availability of funding through the Alumni Small Grants Program. This opportunity is tailored to alumni of U.S. government-funded and U.S. government-sponsored (USG) exchanged programs and seeks projects aimed at enhancing the connections between the United States and Turkmenistan through innovative cultural and professional initiatives that emphasize shared values and promote bilateral cooperation.



Projects are expected to:

- Take place in Turkmenistan including in the American Corners in Dashoguz, Mary and Turkmenabat and American Center in Ashgabat.

- Incorporate cultural elements or draw from the applicant’s U.S. exchange experience in a specific field.

- Foster increased understanding of U.S. policy and perspectives.



Project Goal: Strengthen the capacity of USG alumni, particularly youth from underserved communities in Turkmenistan to participate in economic, educational, and community service activities that emphasize shared values and bilateral cooperation by leveraging USG exchange alumni experience.



Project Audience(s): Audiences may include students (at secondary and university levels), women and girls, journalists, media professionals, entrepreneurs, artists, musicians, and various underserved or vulnerable populations.



Grantees are also encouraged to host programming and take advantage of existing resources at American Center in Ashgabat and American Corners in Dashoguz, Mary and Turkmenabat.



Project Objectives: (Project proposals may address one or more of these objectives, or other objectives within the above policy priorities. NOTE: These are example objectives – PDS will also consider projects with different objectives targets that support the above project expectations.)

Objective 1: Increase alumni engagement through tailored capacity building trainings to support and strengthen the U.S.-Turkmenistan Alumni Association (USTAA).



Objective 2: Equip youth from rural and underserved communities with knowledge and skills related to Science, Technology, Engineering, Art, and Mathematics (STEAM).



Objective 3: Increase English language proficiency skills of youth and young adults from (at secondary and university levels) from Ahal, Balkan, Dashoguz, Mary and Lebap regions or young professionals of specific fields (for example tourism, sports, medicine, STEM) through training and interactive activities (grammar lessons, conversation practice, etc.).



Sub-objective 3.1. Increase English language instruction capacity (professional development for English language teachers through teacher trainings activities.



Objective 4. Build organizational capacity of civil society organizations to improve institutional accountability, transparency, and support for local communities across Turkmenistan.



Objective 5: Equip young adults with media literacy skills to recognize, analyze, and counteract mis/disinformation across various digital media platforms.



Objective 6: Increase awareness and willingness of participants to adopt sustainable practices in their daily lives through community dialogues or workshops on climate change and environmental sustainability.



Objective 7: Equip women, youth and/or residents of remote regions with business and entrepreneurship skills, such as financial literacy, risk management, marketing, and sales, through practical and hands-on training, mentorship, and internship opportunities.



Objective 8: Increase the number of advocacy initiatives aimed at advancing the rights for people with disabilities by raising awareness, promoting inclusive policies, and engaging government stakeholders.



Objective 9: Increase participation of women and youth from vulnerable and marginalized groups, including persons with disabilities, in economic empowerment and civic engagement activities.



Applicants are encouraged to choose one or more project objectives listed above, or suggest their own project objectives, identify indicators that track success towards progress made towards objectives, and develop their own Monitoring and Evaluation (M&E) plans.

Alumni grant proposals must support projects that address a tangible need in a community and have measurable outcomes. Applicants should be encouraged to develop partnerships with the public/private sector as well as local organizations, where applicable.

Below are examples of past Alumni Small grants funded projects:



· Summer and winter EnglishPalooza activities

· “Launch Life: Coding Bootcamp” for girls and women.

· “Technovation Girls Turkmenistan” for girls aged 8 to 18

· Annual Alumni Gala

· “Professional Navigator” for people with disabilities

· “From Disability to Chess-Ability”

· Academic and professional lectures, seminars, training, and/or speaker programs.

Link to Additional Information:
Grantor Contact Information:If you have difficulty accessing the full announcement electronically, please contact:

Public Diplomacy Section
pdsashgabatgrants@state.gov

pdsashgabatgrants@state.gov
if possible suggest my a VBA to do the job
either how to do it power query, or if you can tell me a way using VBA, that's also fine.

PFA, i want the urls in the column A to be loaded automatically by the excel thru power query or VBA and the content of the page to be pasted on column B
Like what I have shown in the attachment, PFA
by the way, i want the same to be done for more than 2000 urls which i've not listed here, so please tell me a way to automate it, even the 3 rows of urls using some sort of loop
Please and thankyou
 

Attachments

  • Screenshot 2024-07-22 162238.png
    Screenshot 2024-07-22 162238.png
    80.5 KB · Views: 8

Excel Facts

Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.
Not for the first time (so make sure it's the last):

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at:

There is no need to repeat the link(s) provided above but if you have posted the question at other places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.
 
Upvote 0
Not for the first time (so make sure it's the last):

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at:

There is no need to repeat the link(s) provided above but if you have posted the question at other places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.
They didn't have a response, only then i posted it. any way i'll go thru the rules
 
Upvote 0
post crossposted here,
 
Upvote 0

Forum statistics

Threads
1,223,932
Messages
6,175,468
Members
452,646
Latest member
tudou

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top