Consulting

Results 1 to 5 of 5

Thread: Taking Bible verses from a site and copying them into Word

  1. #1
    VBAX Newbie
    Joined
    Dec 2023
    Posts
    2
    Location

    Taking Bible verses from a site and copying them into Word

    hello, I am looking for a way to automatically search within a site for bible verses that I am interested in copying and importing into word.
    Unfortunately I am not good at this, and searching the internet I have found absolutely nothing.


    The site where I want to search is "https://www.bibbiaedu.it/CEI2008/nt/".
    and the browser is Microsoft Edge.


    This script should:
    - when activated, bring up a box in which to enter references to the verses to be searched
    - automatically search within the site (either via the site's own search box, or by "dialling" the url like so "https://www.bibbiaedu.it/CEI2008/nt/Fm/1/")
    - Select the text from beginning to end according to the references entered at the beginning
    - paste the text into the word file
    - activate the style I use for citations

    Thank you so much!!!

  2. #2
    VBAX Regular
    Joined
    Sep 2023
    Posts
    97
    Location
    This is what you're trying to do How Can VBA Be Used to Scrape Website Data? (rayobyte.com)


    You might also consider accessing their REST API for bible data, this way you don't have to scrape information from a webpage. Something like the Bible Search (Bible Services (bibliaapi.com)) Create a user and get your own API Key (API Keys (bibliaapi.com)) You can control how much you get back and how it is formatted as well Bible Content (bibliaapi.com)


    Here is a Word document that contains a button that displays a form which allows you to search for a term and return passages it is found in (currently set to a limit of 5 you, can remove that to get all matching passages) using the API. You can look at the code and modify it as you need.

    You can assign the macro that shows the user form (the code in the show form button) to a keystroke instead https://wordmvp.com/FAQs/Customizati...roToHotkey.htm

    I hope it gets you a little further to what you want to get done.
    Attached Files Attached Files

  3. #3
    VBAX Newbie
    Joined
    Dec 2023
    Posts
    2
    Location
    Hi!!! thank you so much for the answering!
    I need to access to the italian version of the bible, CEI 2008 in particular. Unfortunaly there is none on biblia.com
    how i can do?

  4. #4
    VBAX Regular
    Joined
    Sep 2023
    Posts
    97
    Location
    Ah, okay. There is a PDF version of that you can download, https://www.preghiamo.org/download/b...cra-bibbia.pdf. Could you simply open this and search for what you want?

  5. #5
    VBAX Regular
    Joined
    Sep 2023
    Posts
    97
    Location
    Here is a Word document that search the website, you'll need to modify the copy passage code to insert the complete passage into Word and style it with your specific citation, well style.

    You enter a phrase, click search. It uses that sites search engine to return the page passages that contain it (so far, am going to add a button to go to the next page of search results), these are listed in a listbox. When you click on a passage it will show the small preview of the passage their search returns. Then you click the Get Passage to go back to the site and retrieve the entire passage and notes. You can click the copy passage to have what is in the passage textbox copied to the clipboard and you can then paste it where you want.

    This hasn't been tested for every case of searching, you'll need to play with it and tweak it as you need. If you get stuck let me know.
    Attached Files Attached Files

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •