text:
require 'spec_helper'

describe "viewing products", type: :feature, inaccessible: true do
  let!(:taxonomy) { create(:taxonomy, :name => "Category") }
  let!(:super_clothing) { taxonomy.root.children.create(:name => "Super Clothing") }
  let!(:t_shirts) { super_clothing.children.create(:name => "T-Shirts") }
  let!(:xxl) { t_shirts.children.create(:name => "XXL") }
  let!(:product) do
    product = create(:product, :name => "Superman T-Shirt")
    product.taxons << t_shirts
  end
  let(:metas) { { :meta_description => 'Brand new Ruby on Rails TShirts', :meta_title => "Ruby On Rails TShirt", :meta_keywords => 'ror, tshirt, ruby' } }

  # Regression test for #1796
  it "can see a taxon's products, even if that taxon has child taxons" do
    visit '/t/category/super-clothing/t-shirts'
    expect(page).to have_content("Superman T-Shirt")
  end

  it "shouldn't show nested taxons with a search" do
    visit '/t/category/super-clothing?keywords=shirt'
    expect(page).to have_content("Superman T-Shirt")
    expect(page).not_to have_selector("div[data-hook='taxon_children']")
  end

  describe 'meta tags and title' do

    after do
      Capybara.ignore_hidden_elements = true
    end

    before do
      Capybara.ignore_hidden_elements = false
    end

    it 'displays metas' do
      t_shirts.update_attributes metas
      visit '/t/category/super-clothing/t-shirts'
      expect(page).to have_meta(:description, 'Brand new Ruby on Rails TShirts')
      expect(page).to have_meta(:keywords, 'ror, tshirt, ruby')
    end

    it 'display title if set' do
      t_shirts.update_attributes metas
      visit '/t/category/super-clothing/t-shirts'
      expect(page).to have_title("Ruby On Rails TShirt")
    end

    it 'display title from taxon root and taxon name' do
      create(:store)
      visit '/t/category/super-clothing/t-shirts'
      expect(page).to have_title('Category - T-Shirts - ' + Spree::Store.first.name)
    end

    # Regression test for #2814
    it "doesn't use meta_title as heading on page" do
      t_shirts.update_attributes metas
      visit '/t/category/super-clothing/t-shirts'
      within("h1.taxon-title") do
        expect(page).to have_content(t_shirts.name)
      end
    end
  end

  context "taxon pages" do
    include_context "custom products"
    before do
      visit spree.root_path
    end

    it "should be able to visit brand Ruby on Rails" do
      within(:css, '#taxonomies') { click_link "Ruby on Rails" }

      expect(page.all('ul.product-listing li').size).to eq(7)
      tmp = page.all('ul.product-listing li a').map(&:text).flatten.compact
      tmp.delete("")
      array = ["Ruby on Rails Bag",
       "Ruby on Rails Baseball Jersey",
       "Ruby on Rails Jr. Spaghetti",
       "Ruby on Rails Mug",
       "Ruby on Rails Ringer T-Shirt",
       "Ruby on Rails Stein",
       "Ruby on Rails Tote"]
      expect(tmp.sort!).to eq(array)
    end

    it "should be able to visit brand Ruby" do
      within(:css, '#taxonomies') { click_link "Ruby" }

      expect(page.all('ul.product-listing li').size).to eq(1)
      tmp = page.all('ul.product-listing li a').map(&:text).flatten.compact
      tmp.delete("")
      expect(tmp.sort!).to eq(["Ruby Baseball Jersey"])
    end

    it "should be able to visit brand Apache" do
      within(:css, '#taxonomies') { click_link "Apache" }

      expect(page.all('ul.product-listing li').size).to eq(1)
      tmp = page.all('ul.product-listing li a').map(&:text).flatten.compact
      tmp.delete("")
      expect(tmp.sort!).to eq(["Apache Baseball Jersey"])
    end

    it "should be able to visit category Clothing" do
      click_link "Clothing"

      expect(page.all('ul.product-listing li').size).to eq(5)
      tmp = page.all('ul.product-listing li a').map(&:text).flatten.compact
      tmp.delete("")
      expect(tmp.sort!).to eq(["Apache Baseball Jersey",
     "Ruby Baseball Jersey",
     "Ruby on Rails Baseball Jersey",
     "Ruby on Rails Jr. Spaghetti",
     "Ruby on Rails Ringer T-Shirt"])
    end

    it "should be able to visit category Mugs" do
      click_link "Mugs"

      expect(page.all('ul.product-listing li').size).to eq(2)
      tmp = page.all('ul.product-listing li a').map(&:text).flatten.compact
      tmp.delete("")
      expect(tmp.sort!).to eq(["Ruby on Rails Mug", "Ruby on Rails Stein"])
    end

    it "should be able to visit category Bags" do
      click_link "Bags"

      expect(page.all('ul.product-listing li').size).to eq(2)
      tmp = page.all('ul.product-listing li a').map(&:text).flatten.compact
      tmp.delete("")
      expect(tmp.sort!).to eq(["Ruby on Rails Bag", "Ruby on Rails Tote"])
    end
  end
end

redpajama_set_name: RedPajamaGithub


It is intended to detect the average long-run abnormal returns after the one to three years of the event day, and also to discover the suitable long-run abnormal return computational method, the test and the benchmark.
This research period was from January 1985 to December 1999. The monthly data are used to simulate the different sample group, including random sample, non-random sample, cross-sectional dependence of sample observations. Four kinds of computational methods of long-run stock abnormal returns were discussed including accumulation abnormal returns, buy-and-hold abnormal returns, mean monthly calendar-time abnormal returns, the factor model and calendar-time portfolios. Two test, conventional t-statistic and Wilcoxon signed-rank test and two benchmark, reference portfolios, and control firm are used to study.
It is found that mean monthly calendar-time abnormal returns will be well specified. The use of the Wilcoxon signed-rank test was found to yield more empirical rejection levels exceeding theoretical rejection levels. It is suggested that mean monthly calendar-time abnormal returns matched with control firm will reduce most of the misspecification in test statistic.


Wrap yourself up in this soft vintage inspired open cut coat. Find the versatility in this cozy piece as you take it from lounging at home out to the evening showing of the new play in town. Features large front patch pockets and lapel collar. Notes for sizing: the only difference between the sizes is the overall length and the sleeve length.


text:
Coffee Intake May Lower Endometrial Cancer Danger
PHILADELPHIA-- Women who consumed about four cups of coffee each day appeared to have actually lowered endometrial cancer risk compared to those who consumed less than a cup every day, according to a research published in Cancer Epidemiology, Biomarkers & Prevention, a journal of the American Association for Cancer Research. Melissa A. Merritt, PhD
"We utilized a 'nutrient-wide association research study,' a brand-new strategy to systematically evaluate the association of dietary elements with endometrial cancer threat," stated Melissa A. Merritt, PhD, a study fellow in cancer epidemiology at Imperial College London in the United Kingdom. "This method was inspired by genome-wide association studies that look at genetic danger elements for cancer, however in our case we investigated 84 foods and nutrients in place of genes as risk factors for endometrial cancer.
"We confirmed observations from previous studies that having a high versus low intake of coffee was associated with a minimized threat for endometrial cancer, and for the majority of other dietary elements there was no association with endometrial cancer danger," Merritt added.
"Coffee intake deserves investigating additionally to see if coffee can be used for the prevention of endometrial cancer. However, prior to scientific suggestions can be made, more researches are needed to evaluate this question in other research studies and to attempt to separate the parts of coffee that may be liable for any impact on endometrial cancer," Merritt said.
Merritt and colleagues examined the association of 84 foods and nutrients based on nutritional surveys from a prospective cohort research study, the European Prospective Investigation Into Cancer and Nutrition (EPIC) Study. They then verified nine foods and nutrients recognized from the EPIC study as having associations with endometrial cancer threat in 2 prospective cohort studies, the Nurses' Health Study (NHS) and NHSII, two cohorts based at Brigham and Women's Hospital, Boston, and Harvard School of Public Health, Boston, respectively.
Amongst the EPIC research participants, those who consumed about 3 cups of coffee per day (750 g/day) had a 19 percent lower risk for endometrial cancer compared with those who drank less than one cup of coffee daily. Among the NHS/NHSII participants, those who drank about four cups of coffee each day (1,000 g/day) had an 18 percent lower danger for endometrial cancer compared with those who never drank coffee.
This study focused on 1,303 endometrial cancer cases in the EPIC research, and 1,531 endometrial cancer cases from the NHS/NHSII research studies.
The 9 foods/nutrients that were found to have associations with endometrial cancer in the EPIC cohort were overall fat, monounsaturated fat, carbs, phosphorus, butter, yogurt, cheese, potatoes, and coffee.
Total fat, monounsaturated fat, and phosphorus were connected with lowered risk for endometrial cancer, and carbohydrates and butter consumption were associated with enhanced danger for endometrial cancer in the EPIC cohort, however these findings could not be confirmed in the NHS/NHSII cohorts.
The coordination of EPIC is economically supported by the European Commission (DGSANCO) and the International Agency for Research on Cancer. The nationwide cohorts are supported by Danish Cancer Society (Denmark); Ligue Contre le Cancer, Institut Gustave Roussy, Mutuelle Générale de l'Education Nationale, Institut National de la Santé et de la Recherche Médicale (INSERM) (France); Deutsche Krebshilfe, Deutsches Krebsforschungszentrum and Federal Ministry of Education and Research (Germany); the Hellenic Health Foundation (Greece); Associazione Italiana per la Ricerca sul Cancro-AIRC (Italy); Dutch Ministry of Public Health, Welfare and Sports (VWS), Netherlands Cancer Registry (NKR), LK Research Funds, Dutch Prevention Funds, Dutch ZON (Zorg Onderzoek Nederland), World Cancer Research Fund (WCRF), Statistics Netherlands (Netherlands); ERC-2009-AdG 232997 and Nordforsk, Nordic Center of Excellence Program on Food, Nutrition, and Health (Norway); Health Research Fund (FIS), Regional Governments of Andalucía, Asturias, Basque Country, Murcia (no. 6236) and Navarra, ISCIII RETIC (Spain); Swedish Cancer Society, Swedish Scientific Council and County Councils of Skåne and Västerbotten (Sweden); Cancer Research U.K., Medical Research Council (United Kingdom). The NHS/NHSII were supported by the National Institutes of Health. Merritt declares no conflicts of interest.

redpajama_set_name: RedPajamaCommonCrawl


text:
7 Cool Things You Didn't Know About Heir Force One, the Ultra Luxurious Private Jet
No, Heir Force One isn't a typo, but rather a specially converted Airbus A320-232 that features luxury clubman style recliner seats, a large double bed and even a shower room in the presidential area. It's the preferred mode of transportation for Prince Charles on his tour of the United States for a total of 4-days. Continue reading for more.
7. Started Out as a JetBlue Plane
The jet, CS-TFY, started its life as flying for a low-cost airline in United States, JetBlue, before its ultra luxurious conversion, used by the Royals for their flights.
Sure, you get a Nespresso coffee machine as well as WIFI and satellite phones, but you'll pay a hefty price for the, as the MailOnline estimates that the aircraft would cost in the region of £250,000 ($369,511 USD) to charter for a mere 4-days on a trans-Atlantic trip.
5. Presidential Area
This aircraft is based in Paris and even has its own special private zone described as 'the presidential area' billed by its owners as The Head of State.
4. Bathroom
Even the aircraft's toilet, pictured above, is equipped to the highest possible standards, complete with leather and gold. However, there's an even larger shower room for VIPs.
3. Passenger Capacity
Despite using the same airframe chassis as a normal passenger jet, this highly modified version can only safely carry 26 people. For reference, normal jets can transport up to 180 people at once.
Passengers who shell out the hefty cost on can enjoy Wi-Fi internet access throughout the cabin as well as a 10-channel TV system with approximately 200 movies on demand. There are two wall-mounted 42″ displays, along with five smaller 21″ screens. There are a total of eight, 10″ screens in the armrests of the first class cabin.
1. London to Maryland
According to Masterjet's website, a flight from London to Maryland next Tuesday and returning next Friday on a private Airbus 320 corporate jet with 26 passengers would cost you a whopping £205,187 ($303,203 USD). The amount when VAT at 20% is added increases the cost to £246,224 ($363,844 USD).
AviationLuxuryTravel
Most Drones Come with Low Quality Cameras, the Holy Stone F180C Has a 720P HD Cam for $70 Shipped
Smartphone Games are Great, But You Can Get a Sony PS Vita Slim for $169.99 Shipped – Today Only


text:
Patriots Vs. Ravens Highlights: The 1st Half In .GIFs
By Jared Smith@JaredSmithCNY Sep 23, 2012, 10:26pm EDT
Share All sharing options for: Patriots Vs. Ravens Highlights: The 1st Half In .GIFs
A late second-quarter touchdown drive has helped the New England Patriots earn a 20-14 halftime lead over the host Baltimore Ravens at M&T Bank Stadium. The first half of this Week 3 NFL showdown featured two touchdowns and field goals from the Patriots, who scored with seven seconds remaining in the half to earn its six-point lead heading into the locker room.
The go-ahead score was a seven-yard touchdown pass from Tom Brady and wide receiver Julian Edelman, who was pretty amped to score his first TD of the season.
via assets.sbnation.com
Edelman's touchdown was New England second of the night. The first was a two-yard rush by Brandon Bolden, who capped a small three-play, six-yard drive that gave the Patriots an early 10-0 advantage.
Early on, a lot of things went right for the Patriots, however, things did get a bit chippy as Baltimore clawed back into the game and took a 14-13 lead with 1:53 to go in the half. The chippyness did not sit well with Patriots head coach Bill Belichcik.
For more Patriots coverage, check out Pats Pulpit. For more on the Ravens, head over to Baltimore Beat Down.
Patriots Vs. Ravens: New England Defense Falters in 31-30 Loss In Baltimore
Patriots look to get back to .500 against Bills
Patriots Vs. Ravens Halftime Score: New England On Top, 20-14


text:
Coming Out as LGBT
How to Come Out to Strict Religious Parents When You're Gay
1 Figuring Out Your Approach
2 Communicating Effectively
3 Moving Forward After Coming Out
Co-authored by Lauren Urban, LCSW
Last Updated: October 20, 2022 References Approved
This article was co-authored by Lauren Urban, LCSW. Lauren Urban is a licensed psychotherapist in Brooklyn, New York, with over 13 years of therapy experience working with children, families, couples, and individuals. She received her Masters in Social Work from Hunter College in 2006, and specializes in working with the LGBTQIA community and with clients in recovery or considering recovery for drug and alcohol use.
wikiHow marks an article as reader-approved once it receives enough positive feedback. In this case, several readers have written to tell us that this article was helpful to them, earning it our reader-approved status.
The decision to come out as gay can be very difficult. You want to be honest with those you care about, but you don't know how they will react. Things can get even more complicated if you have strict religious parents, especially if they think gay love is a sin. You may be scared that they will be angry or possibly hurtful. It's normal to feel anxious, but you can make the process of coming out slightly less tense if you make a well-thought out plan. It's also a good idea to focus on good communication strategies, and a way to follow-up on the conversation.
Figuring Out Your Approach
{"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/0\/0e\/Come-Out-to-Strict-Religious-Parents-When-You%27re-Gay-Step-1-Version-3.jpg\/v4-460px-Come-Out-to-Strict-Religious-Parents-When-You%27re-Gay-Step-1-Version-3.jpg","bigUrl":"\/images\/thumb\/0\/0e\/Come-Out-to-Strict-Religious-Parents-When-You%27re-Gay-Step-1-Version-3.jpg\/aid704648-v4-728px-Come-Out-to-Strict-Religious-Parents-When-You%27re-Gay-Step-1-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"

\u00a9 2023 wikiHow, Inc. All rights reserved. wikiHow, Inc. is the copyright holder of this image under U.S. and international copyright laws. This image is not<\/b> licensed under the Creative Commons license applied to text content and some other images posted to the wikiHow website. This image may not be used by other entities without the express written consent of wikiHow, Inc.
\n<\/p>

\n<\/p><\/div>"}
Examine your motivation. Before initiating such an important conversation, take some time to think about why you want to have this discussion with your parents. Is it because you are secure in your sexuality and confident that you want to live your life openly? Or are you feeling angry, resentful, and overwhelmed? If you are upset or angry, then it may not be the most appropriate time to share this information.
There are many reasons why you might choose to come out. It is up to you as an individual to decide when it is a good time and when there is a good reason. For instance, maybe you are very close to your parents and you don't like the distance that keeping a secret creates between all of you.
Avoid coming out because of anger. Remember, your sexuality is not a weapon to be used to upset anyone. If you feel that the only result will be a hateful response, consider waiting to have this talk.
{"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/9\/94\/Come-Out-to-Strict-Religious-Parents-When-You%27re-Gay-Step-2-Version-3.jpg\/v4-460px-Come-Out-to-Strict-Religious-Parents-When-You%27re-Gay-Step-2-Version-3.jpg","bigUrl":"\/images\/thumb\/9\/94\/Come-Out-to-Strict-Religious-Parents-When-You%27re-Gay-Step-2-Version-3.jpg\/aid704648-v4-728px-Come-Out-to-Strict-Religious-Parents-When-You%27re-Gay-Step-2-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"

\u00a9 2023 wikiHow, Inc. All rights reserved. wikiHow, Inc. is the copyright holder of this image under U.S. and international copyright laws. This image is not<\/b> licensed under the Creative Commons license applied to text content and some other images posted to the wikiHow website. This image may not be used by other entities without the express written consent of wikiHow, Inc.
\n<\/p>

\n<\/p><\/div>"}
Think about risks and benefits. Consider your living situation. Do you depend on your parents for housing and necessities such as food? Or do they pay your college tuition? Think about the possible consequences of coming out. You want to feel very confident that your parents will continue to support you despite your gayness.[1] X Research source
If you are worried about being kicked out of your home, consider waiting to come out until you are financially independent.
Consider your safety. Are you scared that one or both of your parents may become violent? Make sure you have a plan to get to a safe space if that occurs.
One strategy is to identify a friend who can provide a safe place for you to go if the conversation with your parents does not go well. This space can also give your parents time to reflect on the conversation so you can have a follow-up conversation.
You also want to think about the possible benefits of coming out. For example, this could make your relationship with your parents much stronger.
You might also feel emotionally better and a huge relief knowing that you don't have to keep your sexual identity a secret.
EXPERT TIP
Licensed Psychotherapist
Lauren Urban is a licensed psychotherapist in Brooklyn, New York, with over 13 years of therapy experience working with children, families, couples, and individuals. She received her Masters in Social Work from Hunter College in 2006, and specializes in working with the LGBTQIA community and with clients in recovery or considering recovery for drug and alcohol use.
Prioritize your own health. Psychotherapist Lauren Urban adds: "If you're in full control over how and when you come out to your parents, prioritize your physical and emotional safety over the need to come out. You may want to wait to come out if: you feel unsafe, you live at home, or you don't have control over your own circumstances. If you do come out while living at home, be sure to have a backup plan in the event that your family's response is negative."
Consider different scenarios. Try having a variety of plans ready. For example, if your parents are open to listening to you, figure out exactly how much you want to share. Or, if your parents are angry, what will you do? Will you give them space? Will you talk to another trusted family member, friend or relative? Make sure that, whatever you decide, you are respectful and understand it may take your parents some time to absorb what you've told them.[2] X Research source
Make a plan in case your parents are not supportive. Are you prepared to cut off contact with them? Do you have a safe place to stay, if necessary?
If your parents request space, or if they no longer seem to be hearing you, don't press the issue. This may increase the stress and tension in the moment. Try to set an agreed-upon date and time to have a follow-up conversation. Your parents may not be able to process any more information until they can fully absorb what you have already shared.
{"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/b\/bc\/Come-Out-to-Strict-Religious-Parents-When-You%27re-Gay-Step-4-Version-3.jpg\/v4-460px-Come-Out-to-Strict-Religious-Parents-When-You%27re-Gay-Step-4-Version-3.jpg","bigUrl":"\/images\/thumb\/b\/bc\/Come-Out-to-Strict-Religious-Parents-When-You%27re-Gay-Step-4-Version-3.jpg\/aid704648-v4-728px-Come-Out-to-Strict-Religious-Parents-When-You%27re-Gay-Step-4-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"

\u00a9 2023 wikiHow, Inc. All rights reserved. wikiHow, Inc. is the copyright holder of this image under U.S. and international copyright laws. This image is not<\/b> licensed under the Creative Commons license applied to text content and some other images posted to the wikiHow website. This image may not be used by other entities without the express written consent of wikiHow, Inc.
\n<\/p>

\n<\/p><\/div>"}
Find an ally. Preparing to come out can be a really emotional experience. It is perfectly normal to feel anxious or even scared. Having a good support system can be really helpful in this situation. Before coming out to your parents, make sure that you have at least one ally.[3] X Trustworthy Source Go Ask Alice Medical advice site with content written by health promotion specialists affiliated with Columbia University Go to source
Maybe you've already come out to one or more close friends. Ask them to support you before and after your talk with your parents.
You can also seek support from your college or community's LGBT support center.
Anyone that you really trust can be an ally for you.
Talk to the person about your plan to come out to your parents. Find someone in your support group who is willing to let you stay with them if things do not go well during the discussion.
{"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/d\/dd\/Come-Out-to-Strict-Religious-Parents-When-You%27re-Gay-Step-5-Version-3.jpg\/v4-460px-Come-Out-to-Strict-Religious-Parents-When-You%27re-Gay-Step-5-Version-3.jpg","bigUrl":"\/images\/thumb\/d\/dd\/Come-Out-to-Strict-Religious-Parents-When-You%27re-Gay-Step-5-Version-3.jpg\/aid704648-v4-728px-Come-Out-to-Strict-Religious-Parents-When-You%27re-Gay-Step-5-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"

\u00a9 2023 wikiHow, Inc. All rights reserved. wikiHow, Inc. is the copyright holder of this image under U.S. and international copyright laws. This image is not<\/b> licensed under the Creative Commons license applied to text content and some other images posted to the wikiHow website. This image may not be used by other entities without the express written consent of wikiHow, Inc.
\n<\/p>

\n<\/p><\/div>"}
Organize your thoughts. This is an important conversation so it is a good idea to be as prepared as possible. Try writing down what you want to say before you actually have the discussion. You can even make note cards to keep with you. They can help you to make sure that you have said everything you want to say.[4] X Trustworthy Source Go Ask Alice Medical advice site with content written by health promotion specialists affiliated with Columbia University Go to source
Try practicing with a friend or relative. They can help you figure out the right words.
Try to figure out, at the very least, what you want to use as your opening line. You might say, "Mom and Dad, I have something to tell you. Please listen to me with an open heart and an open mind."
Choose the right time and place. Your parents might be very surprised by your news. Try not to startle them even more by telling them your story as they are on their way out the door to work, for instance. Instead, look for a time where your parents are relaxed and able to give you their full attention.[5] X Research source
It's also important to choose the right place. In many cases, it might be best to do this in private. Your living room might be a good choice.
If you have any concerns about your safety, though, a public place might be a better choice. You could consider a coffee shop. Or you could go to a relative's house if they are supportive of you.
{"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/3\/3c\/Come-Out-to-Strict-Religious-Parents-When-You%27re-Gay-Step-7-Version-3.jpg\/v4-460px-Come-Out-to-Strict-Religious-Parents-When-You%27re-Gay-Step-7-Version-3.jpg","bigUrl":"\/images\/thumb\/3\/3c\/Come-Out-to-Strict-Religious-Parents-When-You%27re-Gay-Step-7-Version-3.jpg\/aid704648-v4-728px-Come-Out-to-Strict-Religious-Parents-When-You%27re-Gay-Step-7-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"

\u00a9 2023 wikiHow, Inc. All rights reserved. wikiHow, Inc. is the copyright holder of this image under U.S. and international copyright laws. This image is not<\/b> licensed under the Creative Commons license applied to text content and some other images posted to the wikiHow website. This image may not be used by other entities without the express written consent of wikiHow, Inc.
\n<\/p>

\n<\/p><\/div>"}
Be direct. When you're nervous, it can be tempting to dance around the subject. However, it is important to make your point clear early in the conversation. Otherwise, your parents might grow confused or frustrated.[6] X Research source
A good opening line could be, "Do you two have time to talk? I have something important to tell you about my sexuality."
You might also choose to wait until you are actually sitting down to talk and say, "I want to let you know that I am gay. I hope that you can support me in being who I am."
{"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/8\/8b\/Come-Out-to-Strict-Religious-Parents-When-You%27re-Gay-Step-8-Version-3.jpg\/v4-460px-Come-Out-to-Strict-Religious-Parents-When-You%27re-Gay-Step-8-Version-3.jpg","bigUrl":"\/images\/thumb\/8\/8b\/Come-Out-to-Strict-Religious-Parents-When-You%27re-Gay-Step-8-Version-3.jpg\/aid704648-v4-728px-Come-Out-to-Strict-Religious-Parents-When-You%27re-Gay-Step-8-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"

\u00a9 2023 wikiHow, Inc. All rights reserved. wikiHow, Inc. is the copyright holder of this image under U.S. and international copyright laws. This image is not<\/b> licensed under the Creative Commons license applied to text content and some other images posted to the wikiHow website. This image may not be used by other entities without the express written consent of wikiHow, Inc.
\n<\/p>

\n<\/p><\/div>"}
Show empathy. Coming out is an emotional experience for you. Try to understand that your parents might be feeling emotional, too. For example, if your dad cries, don't immediately take that as a sign of rejection. He's allowed to process emotions, too.[7] X Research source
If your mom says she needs time to think, allow her some space.
There is a difference between showing empathy and letting people hurt you. If there is any kind of abuse in response to what you've shared (such as insults or verbal abuse), walk away. If you have made arrangements with a supportive friend or family member, go to their house so they can help you through this difficult time.
Actively listen. The best conversations are ones in which everyone contributes and participates. Obviously, you have a lot you want to tell your parents. But remember that they deserve a chance to speak, too.[8] X Research source
Show that you are willing to listen. Maintain eye contact. You can also avoid defensive postures, such as crossing your arms.
{"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/3\/33\/Come-Out-to-Strict-Religious-Parents-When-You%27re-Gay-Step-10-Version-4.jpg\/v4-460px-Come-Out-to-Strict-Religious-Parents-When-You%27re-Gay-Step-10-Version-4.jpg","bigUrl":"\/images\/thumb\/3\/33\/Come-Out-to-Strict-Religious-Parents-When-You%27re-Gay-Step-10-Version-4.jpg\/aid704648-v4-728px-Come-Out-to-Strict-Religious-Parents-When-You%27re-Gay-Step-10-Version-4.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"

\u00a9 2023 wikiHow, Inc. All rights reserved. wikiHow, Inc. is the copyright holder of this image under U.S. and international copyright laws. This image is not<\/b> licensed under the Creative Commons license applied to text content and some other images posted to the wikiHow website. This image may not be used by other entities without the express written consent of wikiHow, Inc.
\n<\/p>

\n<\/p><\/div>"}
Remain calm. In most cases, this will be a very emotional conversation. And remember, it is completely fine to show your emotions. However, remember that you might make more progress if you are able to do so calmly.[9] X Research source
Instead of yelling, "Why won't you listen to me!?" try calmly saying, "It makes me feel frustrated when you keep interrupting me."
Try taking a deep breath before speaking. It's also fine to take a little time to think about what you want to say next before speaking.
{"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/a\/aa\/Come-Out-to-Strict-Religious-Parents-When-You%27re-Gay-Step-11-Version-3.jpg\/v4-460px-Come-Out-to-Strict-Religious-Parents-When-You%27re-Gay-Step-11-Version-3.jpg","bigUrl":"\/images\/thumb\/a\/aa\/Come-Out-to-Strict-Religious-Parents-When-You%27re-Gay-Step-11-Version-3.jpg\/aid704648-v4-728px-Come-Out-to-Strict-Religious-Parents-When-You%27re-Gay-Step-11-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"

\u00a9 2023 wikiHow, Inc. All rights reserved. wikiHow, Inc. is the copyright holder of this image under U.S. and international copyright laws. This image is not<\/b> licensed under the Creative Commons license applied to text content and some other images posted to the wikiHow website. This image may not be used by other entities without the express written consent of wikiHow, Inc.
\n<\/p>

\n<\/p><\/div>"}
Keep the conversation on your terms. This is your news and you want to feel in control of the situation. Remember, your parents do not have the right to verbally abuse you. If you find yourself being shamed or yelled at, you can end the conversation.
You can say, "I understand this is emotional for you, but I will not listen to these hateful words. Please let me know if you would like to continue this conversation when you calm down."
Moving Forward After Coming Out
Provide resources. It's possible that your parents might not know much about what it means to be gay and the process of coming out. You can help them to understand by giving them some helpful information. Offer resources from credible sources.[10] X Research source
Print out some information to have on-hand during the discussion. Your parents will be processing a lot of information during this discussion, and it may be difficult for them to remember the names of organizations, web addresses, or information you share. Have these available in a hard copy so that your parents can read the material when they've had some time to think about the conversation.
Among the printed materials you may want to provide the website for PFLAG, which is an organization that help families and friends learn to be supportive of those who identify as LGBT.[11] X Research source
Additionally, you could provide them with the number or website for the LGBT center on your campus or in your community. They will likely have helpful facts for your parents.
{"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/b\/b8\/Come-Out-to-Strict-Religious-Parents-When-You%27re-Gay-Step-13-Version-3.jpg\/v4-460px-Come-Out-to-Strict-Religious-Parents-When-You%27re-Gay-Step-13-Version-3.jpg","bigUrl":"\/images\/thumb\/b\/b8\/Come-Out-to-Strict-Religious-Parents-When-You%27re-Gay-Step-13-Version-3.jpg\/aid704648-v4-728px-Come-Out-to-Strict-Religious-Parents-When-You%27re-Gay-Step-13-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"

\u00a9 2023 wikiHow, Inc. All rights reserved. wikiHow, Inc. is the copyright holder of this image under U.S. and international copyright laws. This image is not<\/b> licensed under the Creative Commons license applied to text content and some other images posted to the wikiHow website. This image may not be used by other entities without the express written consent of wikiHow, Inc.
\n<\/p>

\n<\/p><\/div>"}
Understand the stages of reaction. It would be ideal if your parents immediately reacted in a positive, supportive way. However, it might take them a while to reach that place. Many people will go through different stages of emotion. Knowing that ahead of time can help you to deal with that.
Your parents may grieve, which is completely normal. They may have had a vision of who you are or what your future will be like; grieving means they're coming to terms with the loss of this vision. The five stages of grief are denial, anger, bargaining, depression, and eventually acceptance, but they don't have to happen in any particular order.
Understand that grieving is very personal, and you can't predict how long your parents will be in any one stage of the process. Grief is also not linear, meaning they may go forwards and backwards, they may experience multiple stages at once, or they may skip over certain stages entirely.
You may be going through a grieving process yourself during this time, over your parents' reaction and your fear of losing the relationship.
{"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/f\/f2\/Come-Out-to-Strict-Religious-Parents-When-You%27re-Gay-Step-14-Version-2.jpg\/v4-460px-Come-Out-to-Strict-Religious-Parents-When-You%27re-Gay-Step-14-Version-2.jpg","bigUrl":"\/images\/thumb\/f\/f2\/Come-Out-to-Strict-Religious-Parents-When-You%27re-Gay-Step-14-Version-2.jpg\/aid704648-v4-728px-Come-Out-to-Strict-Religious-Parents-When-You%27re-Gay-Step-14-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"

\u00a9 2023 wikiHow, Inc. All rights reserved. wikiHow, Inc. is the copyright holder of this image under U.S. and international copyright laws. This image is not<\/b> licensed under the Creative Commons license applied to text content and some other images posted to the wikiHow website. This image may not be used by other entities without the express written consent of wikiHow, Inc.
\n<\/p>

\n<\/p><\/div>"}
Keep lines of communication open. However the conversation ends, try to leave the door open for future talks. Tell your parents that you all need some time to process your emotions, but that you hope you can talk again soon.
If your parents were verbally abusive, you do not need to feel bad about closing the conversation. Remember that no one has the right to make you feel bad about who you are.
Ask your parents if they would be open to attending family counseling/therapy. Look for someone with experience with LGBTQ issues. A mediator can help keep communication clear and respectful.
{"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/6\/6b\/Come-Out-to-Strict-Religious-Parents-When-You%27re-Gay-Step-15-Version-2.jpg\/v4-460px-Come-Out-to-Strict-Religious-Parents-When-You%27re-Gay-Step-15-Version-2.jpg","bigUrl":"\/images\/thumb\/6\/6b\/Come-Out-to-Strict-Religious-Parents-When-You%27re-Gay-Step-15-Version-2.jpg\/aid704648-v4-728px-Come-Out-to-Strict-Religious-Parents-When-You%27re-Gay-Step-15-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"

\u00a9 2023 wikiHow, Inc. All rights reserved. wikiHow, Inc. is the copyright holder of this image under U.S. and international copyright laws. This image is not<\/b> licensed under the Creative Commons license applied to text content and some other images posted to the wikiHow website. This image may not be used by other entities without the express written consent of wikiHow, Inc.
\n<\/p>

\n<\/p><\/div>"}
Build a support system. Whether or not your parents support you, it is important that you find a circle of people that you can count on. Look for friends and relatives you can trust, and turn to then when you need support.[12] X Research source
You can also find support at your campus or community LBGT center.
Your community might also have some LGBT friendly churches where you can go and find new sources of support.
I'm almost 14 and I'm starting to think I'm bisexual. When/if I realize I am, how do I tell them? And when?
Licensed Master Social Worker
Tasha Rube is a Licensed Social Worker based in Kansas City, Kansas. Tasha is affiliated with the Dwight D. Eisenhower VA Medical Center in Leavenworth, Kansas. She received her Masters of Social Work (MSW) from the University of Missouri in 2014.
At certain stages of a youths development, it can be a normal experience to question your sexuality. if you feel close to your parents, and feel that your relationship is open, then talk to them about your concerns. If you don't feel comfortable with that, consider talking to your school social worker. They can help connect you with many resources in your area for healthy support.
I'm too scared to ask my parents if they have a problem with gay people. Is there a way to find out without asking them?
Dr. Chris M. Matsko is a retired physician based in Pittsburgh, Pennsylvania. With over 25 years of medical research experience, Dr. Matsko was awarded the Pittsburgh Cornell University Leadership Award for Excellence. He holds a BS in Nutritional Science from Cornell University and an MD from the Temple University School of Medicine in 2007. Dr. Matsko earned a Research Writing Certification from the American Medical Writers Association (AMWA) in 2016 and a Medical Writing & Editing Certification from the University of Chicago in 2017.
I would suggest watching their reactions to these types of topics when they are interacting with other people, or watching and listening to various forms of media. Do they make any remarks, or do they have any particular behavioral reactions that would hint at their opinion? Listen to how you feel, and only approach the matter with your parents when you feel comfortable and confident about the topic.
Be careful at school and/or work with disclosing your sexual orientation. Being outed can be much more painful than coming out on your own terms.
Talk it over with a trusted friend if you think it will help.
Consider joining an online or physical support group with similar people. It helps you relate and get to know about others who've dealt with the same problems as you yet sorted it out.
Accept That You Are Gay
Come Out As a Gay or Lesbian Teen
Come Out As Gay or Lesbian
Drop Hints That You're LGBT
Come Out As Transgender
Tell Your Parents You Are Bisexual
Come Out to Your Friends
Tell Someone You Are Bisexual
Come Out to Your Parents
Come Out
Tell Your Parents You Are Gay
What Age Should You Come Out? The Average Age & Common Coming Out Experiences
Come Out As Nonbinary
Tell Your Mom You Are Gay
↑ http://www.hrc.org/resources/resource-guide-to-coming-out
↑ https://www.psychologytoday.com/blog/gay-and-lesbian-well-being/201103/should-you-come-out-your-parents
↑ http://goaskalice.columbia.edu/answered-questions/how-can-i-tell-my-religious-parents-im-lesbian-without-them-disowning-me
↑ https://www.pflag.org/tags/comingout
↑ https://www.pflag.org/
This article was co-authored by Lauren Urban, LCSW. Lauren Urban is a licensed psychotherapist in Brooklyn, New York, with over 13 years of therapy experience working with children, families, couples, and individuals. She received her Masters in Social Work from Hunter College in 2006, and specializes in working with the LGBTQIA community and with clients in recovery or considering recovery for drug and alcohol use. This article has been viewed 161,200 times.
Categories: Coming Out as LGBT
Русский:объяснить верующим родителям, что вы гей
Dan Bushmire
"I'm transgender but I couldn't find anything on how to come out as trans. I don't know if the parent I want to come out to is transphobic or not and this article helped a lot."..." more
T. May
"Answers were straight to the point and covered a range of scenarios displayed in a lighthearted format with use of pictures."..." more
Richard Armor
"I'm gay and this helped a lot. All of the my friends think I am low-key gay, but it's not so low-key to me. God bless."..." more
Emma Lentz
"It made me feel a little bit better about my sexuality, thank you."
Olivia Horton
"It encourages me to tell my parents when I'm ready."


text:
Shelby Davidson to Donald A. Glaser
Maxime Faget Biography (1921-)
Maxime Faget holds a position few can claim--spacecraft design engineer. Among his creations are the Mercury capsule, the Apollo command andservice modules, and the space shuttle orbiter.
Faget was born in British Honduras. As a child, he read airplane magazines and Astounding Science Fiction, and built model airplanes. Faget earnedhis B.S. from Louisiana State University in 1943.
Three years later he went to work for the National Advisory Committee for Aeronautics, later renamed National Aeronautics and Space Administration (NASA).At Langley Aeronautical Laboratory in Hampton, Virginia, he designed ramjetsand began a fruitful collaboration with Caldwell Johnson. Faget eventually was assigned to the propulsion-and-performance team that developed the designfor the X-l5, the experimental plane that flew Mach 6. The flight of the Russian satellite Sputnik 1 in 1957 challenged Americans to pursue manned space flight. A space craft must protect its occupant from high G (gravity) forces and atmospheric friction upon re-entry. Faget argued for a blunt bodied capsule because it could slow down high in the atmosphere where the friction and heat were less. Not only was Faget a good designer, but he was equally effective as a debater, winning over those opposed to his idea. In the late 1950s Faget headed the flight systems division that designed the Mercury capsule.
From 1962 to 1981, Faget was the director of engineering and development at the Manned Spacecraft Center, later renamed the Johnson Space Center, in Houston, Texas. Faget and Johnson designed both the Apollo capsule and service module. For the lunar missions, Faget liked the direct approach method inwhich a huge rocket launched the command-and-service module that would landon the moon as a single unit and return to the earth. A serious drawback wasthe huge rocket needed for takeoff and lunar landing, so Faget converted it to the final form in which the command-and-service module went into lunar orbit with a small lunar-landing craft attached. This system required much less weight for earth launch.
Even before the lunar landings, NASA wanted plans for a reusable space shuttle. Though Faget envisioned a straight-wing plane for greater maneuverability,NASA opted for the delta-shaped design. Faget also argued unsuccessfully forengines that could swing into the payload bay for easier re-entry and one piece solid-rocket boosters, designs that, if used, might have prevented the Challenger disaster and eliminated the hydrogen-leak problem that grounded thefleet for six months.
In 1981 Faget left NASA to work for the aerospace firm Eagle Engineering, andin 1983 he founded Space Industries, Inc. to design an industrial space facility.
October 9, 2004: Faget died on October 9, 2004, at his home in Houston, Texas, of cancer. He was 83. Source: Washington Post, www.washingtonpost.com, October 12, 2004; New York Times, www.nytimes.com, October 12, 2004; CNN.com, www.cnn.com, October 11, 2004.


This spectacular complex of Beach front houses offers 2 types of apartments; 2 bedrooms 1 livingroom with sleeps up to 6 persons with sofa bed and 1 bedroom 1 livingroom with sleeps up to 4 persons with sofa bed.
One bedroom apartment with fabulous sea views, and your very own private sandy beach right on the door step. Ideal get away for families and couples looking for a quiet and relaxing atmosphere, endless blue skies, turquoise waters and breath taking sunsets.
Beautiful one bedroom apartment with balcony and sea view, right on the beach. The apartment is fully funrnished and equipped with all modern conveniences to make your holiday relaxing and enjoyable.
The kitchen/dining area is open plan with the living room which opens out onto the balcony where you can enjoy stunning sea views and sunsets in the evenings.
It is offering perfect opportunities for swimming, sunbathing and water sports on the beaches of Bodrum by the clear blue sea, each has a distinguished beauty of its own possessing distinct natural and environmental beauties. Endless blue skies, turquoise waters, sun filled days and evenings spent sampling the local delights and dancing till dawn. You can make a good use of possibilities of water sports, diving, daily boat trips, and other excursions to make your stay really worthwhile.
You can visit the splendid Bodrum Castle, The Tomb of King Mausolus, the antique theatre, market and bazaars around Bodrum.


text:
Q: convert string back into object in r In R, I get the content of a binary file as a string (because of design issues, I can't access the file directly).
This file was originally an lm model.
How do I convert that string back into the lm model?
Thanks

A: I'm assuming you used base::dput() according to the following example (based on this answer):
# Generate some model over some data
data <- sample(1:100, 30)
df <- data.frame(x = data, y = 2 * data + 20)
model <- lm(y ~ x, df)

# Assuming this is what you did you have the model structure inside model.R
dput(model, control = c("quoteExpressions", "showAttributes"), file = "model.R")

# ----- This is where you are, I presume -----
# So you can copy the content of model.R here (attention to the single quotes)
mstr <- '...'

# Execute the content of mstr as a piece of code (loading the model)
model1 <- eval(parse(text = mstr))

# Parse the formulas
model1$terms <- terms.formula(model1$terms)

# ----- Test it -----
# New data
df1 <- data.frame(x = 101:110)

pred <- as.integer(predict(model, df1))
pred1 <- as.integer(predict(model1, df1))

identical(pred, pred1)
# [1] TRUE

model
#
# Call:
# lm(formula = y ~ x, data = df)
#
# Coefficients:
# (Intercept)            x
#          20            2
#

model1
#
# Call:
# lm(formula = y ~ x, data = df)
#
# Coefficients:
# (Intercept)            x
#          20            2

# Check summary too (you'll see some minor differences)
# summary(model)
# summary(model1)

redpajama_set_name: RedPajamaStackExchange


Berkshire Hathaway HomeServices Florida Network Realty is pleased to welcome Kaitlyn Shaw to the St. Augustine office with locations in St. Augustine Beach and MuraBella at World Golf Village.
Recently graduated from the University of Central Florida with a Bachelor of Science Business Administration in Real Estate, Kaitlyn is excited to begin her career as a Realtor in the St. Augustine office of Florida Network Realty. Born and raised in St. Augustine, Kaitlyn has returned to her home city to begin her career in real estate, and she is eager to help her clients find a house that they can call their home in the city and community that she loves.
Kaitlyn has two rescue dogs, Jojo and Xena, who light up her world! In her spare time, she enjoys volunteering at the local animal shelter to help other dogs find their "forever home." As a Realtor, she can't wait to do the same for her future clients – help them find their forever home!
"I am excited to welcome Kaitlyn to the St. Augustine Office! Kaitlyn has a strong desire to help her customers achieve their home buying and selling goals. We are very excited that she has decided to join Berkshire Hathaway HomeServices Florida Network Realty," shares Ann King, Broker/Manager of the St. Augustine and MuraBella at World Golf Village offices.
For more information, Kaitlyn can be reached by phone at 904.540.7665 or at Kaitlyn.Shaw@FloridaNetworkRealty.com and website: KaitlynsProperties.com. The St. Augustine offices in St. Augustine Beach and MuraBella at World Golf Village are located at 112 Sea Grove Main Street, Suite 210, St. Augustine Beach, FL 32080 and 196 Capulet Drive, Suite 3, St. Augustine, FL 32092.


The is an interactive session with Moshe David Hacohen and Salahuddin Barakat/Madrasa. The participants will engage the public with a joint sharing of the traditional Jewish Beit Midrash and the Muslim Madrasa – learning and comparing interpretations of the Biblical story of the sacrifice of Abraham's son. Which son was this? Come to find out!
Moshe David Hacohen moved almost one year ago with his wife and five children from Israel to Malmö. He serves as the rabbi of the Judiska Församlingen in Malmö as well as co-directs Amanah: The Muslim and Jewish Trust and Faith Project with Imam Salahuddin Barakat – which fosters bonding between the Jewish and Muslim communities in Malmö. He is completing his PhD studies and dissertation in Jewish history and philosophy at the University of Haifa.
Previous Story Previous post: När är det kosher att pruta?
Program 2018 – Kan man vaccinera ungdomar mot antisemitism genom resor till Auschwitz?


text:
Taking A Chance On Love
Music by Vernon Duke
Originally Performed by Jackpot! (Region 9)
"Taking a Chance on Love" is a popular song by Vernon Duke with lyrics by John La Touche and Ted Fetter, published in 1940, which has become a standard recorded by many artists. It was introduced in the 1940 show Cabin in the Sky, a ground-breaking Broadway musical with an all black cast, where it was performed by Ethel Waters and Dooley Wilson. A feature film version Cabin in the Sky, starring Waters and Eddie "Rochester" Anderson, was released in 1943 and featured the song. A Benny Goodman cover featuring Helen Forrest reached #1 in 1943.
Songbooks, Arrangements and/or Media
Displaying 1-21 of 21 items.
Darmon Meader : Vocal Jazz Love Songs
"Love Is Here to Stay" was the last one written by George Gershwin before his untimely death at the age of 39. New York Voices' Darmon Meader has arranged it in a classic a cappella vocal jazz style, with surprisingly little divisi for such a full-sounding arrangement. An extraordinary song, an extraordinary arrangement. Darmon takes a swinging approach to "Taking a Chance on Love", with a tight vocal arrangement accompanied by piano or optional jazz trio. Clever lyrics make it a real audience pleaser, and your singers will appreciate the masterly vocal writing. Vocal jazz groups: don't miss it. "I Can't Believe That You're in Love with Me" was recorded by New York Voices on their Sing, Sing, Sing album.
Songlist: I Can't Believe That You're in Love with Me, Taking A Chance On Love, Love Is Here to Stay
Voicing: SATB | Performed by New York Voices | 6742b | Sheet Music | $6.75
Barbra Streisand : Music of the Stars
20 gems of the great American songbook as song by the inimitable Ms. Streisand, including: But Beautiful - It Had to Be You - More Than You Know - Second Hand Rose - Smile - Some Day My Prince Will Come - Taking a Chance on Love - and more.
Songlist: Great Day, Smile, More Than You Know, The Best Things In Life Are Free, But Beautiful, It Had To Be You, Free Again (Non... C'est Rien), For All We Know, I've Got No Strings, Keepin' Out Of Mischief Now, My Buddy, My Honey's Loving Arms, My Man (Mon Homme), Second Hand Rose, Some Day My Prince Will Come, Taking A Chance On Love, They Didn't Believe Me, (I Stayed) Too Long At The Fair, What Now My Love, Who's Afraid Of The Big Bad Wolf?
Voicing: Solo | Performed by Barbra Streisand | 40161b | Songbook | $14.95 | PVG
John Kander and Fred Ebb : New York, New York
The Man I Love * A New Kind of Love * Once in a While * You Are My Lucky Star * Don't Be That Way * Blue Moon * Don't Get Around Much Anymore.
Songlist: Theme from "New York, New York", There Goes the Ball Game, Blue Moon, But the World Goes 'Round, Do Nothin' Till You Hear from Me, Don't Be That Way, Don't Get Around Much Anymore, Happy Endings, Honeysuckle Rose, It's a Wonderful World, Just You, Just Me, A New Kind of Love, Once in a While, Taking a Chance on Love, The Man I Love (from "Strike Up the Band"), You Are My Lucky Star
Voicing: Solo | 40068b | Songbook | $15.95 | PVG
Johnny Mathis : Deluxe Collection
Over 30 great songs by America's finest songwriters as sung by the incomparable Johnny Mathis, including: Chances Are - It's Not for Me to Say - A Marshmallow World - Misty - Mood Indigo - The Most Wonderful Time of the Year - The Twelfth of Never - Wonderful! Wonderful! - and more.
Songlist: Goodnight My Love, Pleasant Dreams, I Just Found Out About Love, Come To Me, Those Were The Days, Chances Are, Gina, What Will Mary Say?, More Than You Know, Where Are You, I'll Be Easy To Find, Fly Me To The Moon (In Other Words), The Impossible Dream (The Quest), It's All In The Game, It's Not For Me To Say, Where Do I Begin (Love Theme), A Marshmallow World, Misty, Mood Indigo, The Most Wonderful Time Of The Year, Only You (And You Alone), Stranger In Paradise, Taking A Chance On Love, That Sunday That Summer (If I Had To Choose), Too Close For Comfort, Too Much, Too Little, Too Late, The Twelfth Of Never, When I Am With You, Wild Is The Wind, A Wonderful Day Like Today, Wonderful! Wonderful!, and more
Voicing: Solo | Performed by Johnny Mathis | 40164b | Songbook | $19.95 | PVG
Liza Minnelli : Original Keys For Singers
25 signature standards from this Oscar-, Tony- and Emmy-winning superstar, all transcribed exactly as sung, in their original keys! Foreword by Michael Feinstein.
Songlist: And All That Jazz, But The World Goes 'Round, Cabaret, City Lights, Colored Lights, Liza With A 'Z', Losing My Mind, Maybe This Time, Me And My Baby, Mein Herr, Money, Money, Money Tree, My Own Best Friend, My Own Space, Theme from New York, New York, Nowadays, A Quiet Thing, Ring Them Bells, Sara Lee, Shine It On, Sing Happy, The Singer, Stepping Out - Main Title, Taking A Chance On Love, There When I Need Him
Voicing: Solo | Performed by Liza Minnelli | 5167b | Songbook | $19.95 | Voice and Piano
Tony Bennett : Music of the Stars
The Music of the Stars series highlights some of the greatest singers of all time. Collect them all for an unbeatable library of standards! Volume 1 features 15 Tony Bennett songs arranged with vocal melody, lyrics, piano accompaniment and chord names. Songs include: Body and Soul - Chicago - Do Nothin' Till You Hear from Me - I'm Always Chasing Rainbows - Love Story (Where Do I Begin?) - Sentimental Journey - September Song - Speak Low - Waltz for Debby - and more.
Songlist: I'm Always Chasing Rainbows, Because Of You, Close Your Eyes, Are You Havin' Any Fun?, I'll Only Miss Her When I Think Of Her, Body And Soul, Chicago (That Toddlin' Town), There Will Never Be Another You, September Song, Do Nothin' Till You Hear From Me, I Won't Cry Anymore, The Moment Of Truth, I've Got The World On A String, Where Do I Begin (Love Theme), Sentimental Journey, Speak Low, Taking A Chance On Love, Waltz For Debby, What A Wonderful World, When Joanna Loved Me, Who Can I Turn To (When Nobody Needs Me), When Lights Are Low
Voicing: Solo | Performed by Tony Bennett | 40156b | Songbook | $14.95 | PVG
Various Arrangers : The Great American Songbook - Jazz
A great resource of 100 classics of American songwriting arranged for piano and voice with guitar chord frames.
Songlist: Love You Madly, Dancing In The Dark, All Alone, All Blues, All Or Nothing At All, The Lamp Is Low, Almost Like Being In Love, Alone Together, Along Came Betty, Lucky To Be Me, And The Angels Sing, Angel Eyes, As Time Goes By, Sweet Lorraine, Summertime, Star Eyes, Django, There Is No Greater Love, Bernie's Tune, Between The Devil And The Deep Blue Sea, Billie's Bounce (Bill's Bounce), Blue Moon, Bluesette, Emily, If I Had You, But Not For Me, Allen's Alley, Reunion Blues, Can't We Be Friends, Just Friends, and more
Voicing: Solo | 2559b | Songbook | $24.95 | PVG
Four Lads : Breezin' Along / On The Sunny Side
The Four Lads transition from singing together as Canadian choir boys, to stardom at New York's Le Ruban Bleu, to being voted America's favorite vocal group, is the stuff of music industry legend, but it's their fresh, jazzy, exuberant sound that we're interested in. Blessing again the record executive who first combined two classic lps on one CD for the price of one, we have 24 tracks here, all orchestrally accompanied, but the emphasis is on the four amazing singers. On "Breezin'," are songs like "That Old Feeling," "Someone Like You," "Long Ago (And Far Away)," "Someone To Watch Over Me," "Come To Me" and "A Lovely Way To Spend An Evening." On "Sunny," there's "The Things We Did Last Summer," "Bidin' My Time," "Makin' Whoopee" "Dancing In The Dark," "Lazy River," and "Side By Side." A generous helping of the Lads' contagiously jazzy, 60s nightclub sound!
Songlist: Breezin' Along With The Breeze, That Old Feeling, Swingin' Down The Lane, Someone Like You, You Were Meant For Me, Hit The Road to Dreamland, Long Ago (And Far Away), That's My Desire, Someone To Watch Over Me, I'll String Along With You, Come To Me, A Loverly Way To Spend An Evening, On The Sunny Side Of The Street, The Things We Did Last Summer, Taking A Chance On Love, Biden' My Time, Makin' Whoopee, Sentimental Journey, These Foolish Things, Wrap Your Troubles in Dreams, Dancing in the Dark, Lazy River, The Way You Look Tonight, Side By Side
4472c | 1 CD | $14.98 | Accompanied
Jackpot! : Can You Hear Me Now?
Kay, Gina, Joanie and Jan-Winter Park, Florida's Jackpot! Quartet, has been together for over 6 years now and are the 2009 Sweet Adelines International 2nd place finalists. These 12 rock-solid Sweet Adelines standards show us what was clear to the judges - this quartet has big voices, big harmonies and the kind of wonderful, ringing chords rarely heard in a Sweet Adelines group. Favorites are "Taking a Chance on Love," "Unforgettable," "For Once in My Life," "Almost Like Being in Love," "Easy Street," "Money Medley," "I'll Take Romance" and "How Deep is the Ocean." The debut CD "Can You Hear Me Now" has the good stuff, certainly one of the best Sweet Adelines recordings we've heard in a long time, by one of Sweet Adelines' top quartets!
Songlist: Blue Skies, I've Got The World On A String, Taking A Chance On Love, That's Life!, Unforgettable , For Once in My Life, Almost Like Being In Love, Somewhere Over The Rainbow, Easy Street, Money Medley, I'll Take Romance, How Deep Is The Ocean?
5847c | 1 CD | $14.95 | A Cappella
Marquis : Diamond Cuts
1995 International Champions, Marquis begins their recording with the final song from their winning competition, "With A Song In My Heart," arranged by Jim Clancy. And so these winners share with us the Nat King Cole hit, "When I Fall In Love," Walter Latzko's arrangement of "Give Me The Simple Life," Bill Mitchell's arrangement of "Never Never Land," their opening tune from the final round of the gold medal pursuit "I Found A Million Dollar Baby In A Five-And-Ten Cent Store" and Greg Volk's jazz arrangement of "Paper Moon." This reviewer thanks Marquis not only for marvelous singing but their willingness to share the credit with coaches and arrangers in great notes!
Songlist: With A Song In My Heart, When the Midnight Choo-Choo Leaves for Alabam', When I Fall in Love, Give Me the Simple Life, Never Never Land, I Found a Million Dollar Baby in a Five-And-Ten Cent Store, What Kind of Fool Am I, Taking A Chance On Love, The Sweetheart Tree, It's Only a Paper Moon, Gypsy Love Song, Watch What Happens, I Will Never Pass This Way Again
New Tradition Chorus : Sentimental Journey
Northbrook, IL's 95-strong NTC, founded in 1982 as a performance and competition chorus and the intention of becoming one of the best men's choruses in the world, reached that goal in 2001, when, after 8 years of second place medals, they won the coveted gold. Director and arranger Jay Giallombardo, who was a charter member of the group and a member of SPEBSQSA since 1968, has made his devotion to musical quality a guiding light for New Tradition since its inception. That smooth, powerful quality is clear on all of "Sentimental's" 13 classic cuts: "Big Band Days," "Tuxedo Junction," "Taking a Chance on Love," "Skylark," "Everything Old Is New Again," "Do Nothin' 'Till You Hear from Me," "You Must Have Been A Beautiful Baby," "Java Jive," a stunning "The White Cliffs of Dover" (recorded live at the 2001 SPEBSQSA Chorus Finals), a marvelous "Gershwin Medley," "Imagination," the lovely title tune, and a live bonus track, "dedicated to the heroes of Sept. 11, 2001." "Sentimental" is a nostalgic treat from start to finish by one of the best choruses on the planet.
Songlist: Big Band Days, Tuxedo Junction, Taking A Chance On Love, Skylark, Everything Old Is New Again, Do Nothin' Till You Hear from Me, You Must Have Been a Beautiful Baby, Java Jive, The White Cliffs of Dover, Gershwin Medley, Imagination, Sentimental Journey
Sweet Adelines : Top Quartets 2009
Lovers of the exciting live Quartet Finals at the International Sweet Adelines Convention will want to settle back and savor this 63rd Annual 2009 Nashville Quartet Finalists collection! A new twist this year is including songs from 13 groups, besides the Gold, Silver and Bronze medalists and 4th through 10th place finishers, the top three "Rising Star" Quartets, Vogue from Orange County, CA, The Brats from Quebec, Canada, and Extra Shot from Hamilton, New Zealand. Olathe, Kansas-based Gold winner Zing! has 4 tunes, including "Zing Went the Strings of My Heart" and "You Turned the Tables on Me;" Winter Springs, Florida-based Silver winners Jackpot! has 3 songs, including "Taking a Chance on Love;" and Edgewater, Maryland-based Bronze winners, and Harmony Sweeps champs Maxx Factor have 3, including the Disney favorite "When You Wish Upon a Star." The 4th through 10th finishers are Oregon's Martini, Florida's Journey, Maryland's Capri, California's Razzcals, Sweden's Remix, Seattle's Mojo and Canada's Spritzer. A wonderfully rich collection from Sweet Adelines' Finest Quartets!
Songlist: If I Give My Heart To You, Flirty Eyes, Goody Goodbye, If You Love Me, Really Love Me, I Can't Give You Anything But Love/ I've Got A Feeling I'm Falling, Oh, You Beautiful Doll, If I Love Again, How Many Hearts Have You Broken? , Roses of Yesterday, At Last, Put Your Arms Around Me, Honey, May I Never Love Again, How Are Things In Glocca Morra?, My Baby Just Cares For Me, All The Way, Don't Break The Heart That Loves You, When You Wish Upon A Star, Powder Your Face With Sunshine/ Smile, Dam Ya, Smile, Over The Rainbow, Taking A Chance On Love, You Turned The Tables On Me, My Foolish Heart, What'll I Do?, Zing, Went The Strings of My Heart
Another great Sweet Adelines International convention took place this year, and this one was especially exciting as it was held in Las Vegas, Nevada! The Bay Area favorite, the Razzcals did quite well this year, taking 3rd Place. Four Betty's, who also put on a great show at our 2005 Harmony Sweepstakes, Chicago Regional, grabbed 2nd place. This year's Queens, SALT, stole the show, reminding us once again, so many great performers/musicians have come out of Sweden. This CD features two tracks from the quartets placing 4th - 10th, three tracks from Four Bettys and the Razzcals, and we get to hear four tracks from SALT! If you're looking for the best in Sweet Adelines' recordings, this collection definitely delivers!
Songlist: Side By Side, Young And Foolish, What'll I Do, That's My Weakness, I Had Someone Else Before I Had You, At Last, Forgive Me , Changes Medley, Smile Medley, How Deep Is The Ocean, Zing Went The Strings Of My Heart, If You Love Me, I Can't Give You Anything But Love , Taking A Chance On Love, Over The Rainbow, With Plenty Of Money And You , Roses Of Yesterday, Love Medley, There Goes My Heart, I'm Alone Because I Love You, Two Tickets To Georgia, Kiss Me One More Time, I Love Jazz , If You Wee The Only Girl In The World, Who'll Take My Place When I'm Gone, When The Red Robin Comes Bob Bobbin Along
The first week of October, 2005 saw dozens of the best Sweet Adelines Quartets gather in Detroit, MI to compete for the coveted Gold Medals (and, we might add, really cool crowns) that are awarded to the best quartet in the known world! One of our favorite groups, Roseville, CA's Razzcals, took 4th, Elmhurst, IL's Four Bettys were 3rd, Huddinge, Sweden's Salt took the Silver, and four hometown girls, China, MI's Spotlight won it all! This CD features at least 2 songs each by the top 10 finishers, (#10 being Vox from Jarfalla, Sweden, one of 3 Swedish groups in the top 10), 3 songs each by #'s 4, 3 and 2, and 4 tunes by the Champs. Favorites among the 26 cuts are "My Foolish Heart" by Spotlight, "If I Were the Only Girl in the World" by Salt, "Kiss Me One More Time" by Four Bettys, and "Love Medley" by Razzcals. Nice color pix of the 10 groups in the liner notes.
Songlist: The Jazz Me Blues, A Nightingale Sang, How Deep Is The Ocean , I'm Sittin' On The Top Of The World, Roses Of Yesterday, Yes Sir, That's My Baby , I Never Meant To Fall In Fall , Over The Rainbow , Taking A Chance On Love, If I Had My Way, My Honey's Lovin' Arms, What'll I Do, Tears For Souvenirs, When The Midnight Choo Choo Leaves For Alabam', Oh How I Miss You Tonight , Kiss Me One More Time , Who'll Take My Place When I'm Gone, If I Were The Only Girl In The World, If We Can't Be The Same Old Sweethearts, My Foolish Heart, All Bound Round
Convention and Competition in Calgary, Saskatchewan are as exciting and electric as it gets, and this CD has the top ten winners live! Photos of these groups in their beautiful matching outfits give us a taste of what it was like to be there, and the recordings are the next best thing. Four Bettys from Elmhurst, IL took the gold, and they are given four tunes: "Put Your Arms Around Me, Honey," "Oh, How I Miss You Tonight," "I'm Alone Because I Love You" and "How Many Hearts Have You Broken;" Jackpot! from Winter Springs, FL was 2nd and sing 3 songs, including "How Deep is the Ocean;" Razzcals from Roseville, CA took 3rd and sing "Flirty Eyes" and 2 others; Moxie Ladies from Columbus, OH were 4th and sing "Love Medley" and 2 others; and Capri, from Odenton, MD were 5th and sing "At Last" and 2 others. The 6th through 10th place finishers, Mojo, Zing!, Cabaret, Shimmer! and Jukebox respectively, have two songs apiece. If you love Sweet Adelines, Barbershop and spirited, ringing harmonies, this recording will be pure joy for you from chord one!
Songlist: Forgive Me, Changes Medley: There'll Be Some Changes Made, Tired Of Me, After My Laughter Came Tears, You Turned The Tables On Me , Young and Foolish, Love Medley: I Can't Give You Anything But Love, If You Love Me Really Love Me, Oh, You Beautiful Doll, Johnny Medley: Johnny's In Town, At Last, It's The Girl, Roses Of Yesterday, Love Medley: I Can't Give You Anything But Love, It's You, I've Got A Feeling I'm Falling, There Goes My Heart, Flirty Eyes, My Mother's Eyes, Money Medley: With Plenty Of Money and You, How Deep Is The Ocean?, Taking A Chance On Love, Put Your Arms Around Me, Honey, I'm Alone Because I Love You, How Many Hearts Have You Broken?
Sweet Adelines International chose beautiful Honolulu for their 62nd Annual Convention and Competition, and Columbus Ohio's Moxie Ladies took the Gold from a very strong and talented field. They have 3 songs on this exciting, electric DVD: "It's You, Wilson," "Yes Sir, That's My Baby" and "My Man." Silver went to Winter Springs, Florida's Jackpot!, also with 3 tunes including "How Deep is the Ocean;" Roseville, California's popular Razzcals won Bronze and sing "Fifty Eyes" and 2 other songs, and Edgewater, Maryland's Maxx Factor, 2009 winner of the Harmony Sweepstakes, won 4th and sing "We'll Sing All We Know" and "Listen to that Dixie Band." The 5th through 10th place winners, Capri, Mojo, Zing!, Martini, Affinity and Sparx, have 3 to 4 songs apiece. If you missed Honolulu, or want to experience again that amazing competition, this CD is for you!
Songlist: So Long, Dearie, You Can't Go On Forever Breaking My Heart, You Must Have Been A Beautiful Baby, Floatin' Down to Cotton Town, All The Way, Don't Break the Heart That Loves You, Zing Went the Strings of My Heart, If You Love Me, Really Love Me, Oh, How I Miss You Tonight, Oh, You Beautiful Doll, Roses of Yesterday, It's The Girl, I Had the Craziest Dream, Young and Foolish, Listen To That Dixie Band, Lonesomest Girl In Town, If I Only Had A Brain, Flirty Eyes, There Goes My Heart, Taking A Chance On Love, Over The Rainbow, Medley: With Plenty of Money and You/We're In The Money, Medley: I Can't Give You Anything But Love, It's You, Pal Of My Cradle Days, Yes Sir, That's My Baby
Rosemary Clooney : Girl Singer - Songs from the Classic Television Series
Rosemary Clooney's career began in 1945, singing duets with her sister Betty for WLW Radio in Cincinnati. In 1947, they joined the Pastor band as "The Clooney Sisters," making their debut at The Steel Pier in Atlantic City. Two years later, Rosemary signed a solo recording contract with Columbia Records. Clooney recorded her first single, "Come On-a My House," in 1951. It was an immediate and enormous success and catapulted Rosemary to stardom. Her horizons soon expanded to include motion pictures, including the classic "White Christmas" in 1954. In 1956-1957 "The Rosemary Clooney Show" joined CBS television's weekly variety show lineup. Clooney also gave birth to five children, Miguel, Maria, Gabriel, Monsita, and Rafael, between February 1955 and March 1960. This program includes a compilation of 19 musical performances by Rosemary from her 1950's television program, The Rosemary Clooney Show including My Blue Heaven and Mambo Italiano.
Songlist: Tenderly, Botch-A-Me, Mambo Italiano, Moonlight In Vermont, My Blue Heaven , How About You, I've Got My Love To Keep Me Warm, There Will Never Be Another You, Lullaby Of Broadway , I Can't Believe That You're in Love with Me, A Foggy Day (In London Town), You Make Me Feel So Young, Chicago, That Toddlin' Town , Dream, Just You, Just Me, I Got It Bad (and That Ain't Good), Too Marvelous For Words, This Ole House, They Can't Take That Away From Me, Taking A Chance On Love, Blues In The Night , Come On / A My House , Hey There , Up A Lazy River, I'll Be Seeing You , Haven't Got A Worry
Voicing: Solo | Performed by Rosemary Clooney | 5867dvd | DVD | $19.95
Sweet Adelines : Top Quartets & Choruses 2009
Now you can enjoy both the top quartets and choruses as this year both are on the always fabulous Sweet Adelines International National Finals competition. Held this year in Nashville you can relive the experience on the great collection of the best of the best.
Songlist: Taking A Chance On Love, Over The Rainbow, I've Got The Will, Zing, Went The Strings of My Heart, What'll I Do?, Love of My Life, Crazy Little Thing Called Love, Don't Break The Heart That Loves You, All The Way, That's Life, Something Stupid, Nine to Five, If I Had My Way, Mama Mia, Fit as a Fiddle, I'll Never Stop Loving You, Yes Sir, That's My Baby, Powder Your Face With Sunshine/ Smile, Dam Ya, Smile, A Nightingale Sang In Berkeley Square, I Love Jazz/ Take Me To The Land Of Jazz, If I Had My Way, Nothing Can Stop Me Now, Feelin' Good, The Way You Look Tonight, The Old Piano Roll Blues, When the Red, Red Robin, If I Loved You, I'm Nobody's Baby, Facade, If I Give My Heart to You, and more
2784dvd | DVD | $39.95 | A Cappella
Sweet Adelines International chose beautiful Honolulu for their 62nd Annual Convention and Competition, and Columbus Ohio's Moxie Ladies took the Gold from a very strong and talented field. They have 3 songs on this exciting, electric DVD: "It's You, Wilson," "Yes Sir, That's My Baby" and "My Man." Silver went to Winter Springs, Florida's Jackpot!, also with 3 tunes including "How Deep is the Ocean;" Roseville, California's popular Razzcals won Bronze and sing "Fifty Eyes" and 2 other songs, and Edgewater, Maryland's Maxx Factor, 2009 winner of the Harmony Sweepstakes, won 4th and sing "We'll Sing All We Know" and "Listen to that Dixie Band." The 5th through 10th place winners, Capri, Mojo, Zing!, Martini, Affinity and Sparx, have 3 to 4 songs apiece. If you missed Honolulu, or want to experience again that amazing competition, this DVD is for you!
It was cocktail time in Houston when Martini were crowned the new Queens of Harmony. Corrina Garriock, Michelle Shoemaker, DeAnne Haugen and Shannon Harris took top honors with Touce coming second and AKA third.
Songlist: Yes Sir, That's My Baby, Time After Time, Handful of Keys, You Don't You Won't, Happy Together, Till There Was You, Hit That Jive Jack, What Kind of Fool Am I, Ya Gotta Know How To Love, Desperado, Happy Together, Yesterday I Heard The Rain, Good Luck Charm, Goodbye, World, Goodbye, How Many Hearts Have You Broken?, Seasons of Love, If You Love Me, Really Love Me, Hallelujah, This Could Be The Start Of Something Big, At Last, I Don't Care if The Sun Don't Shine, Taking A Chance On Love, Flirty Eyes, Once Upon a Time, Bohemian Rhapsody, I'll Never Say "Never Again" Again, If I Love Again, Love Will Keep Us Together, I Wish, Open Arms, and more
Individual Folios
Darmon Meader : Taking A Chance On Love
Darmon Meader takes a swinging approach to this pop/jazz standard, with a tight vocal arrangement accompanied by piano or optional jazz trio. Clever lyrics make it a real audience pleaser, and your singers will appreciate the masterly vocal writing. Vocal jazz groups: don't miss it.
Arranger: Darmon Meader | Composer: Vernon Duke Performed By: New York Voices
Voicing: SATB | Sheet Music | $1.95 | With Piano |
(Minimum order 4 copies) | 00-27310
Vocal Harmony Arrangements - Home
Christian | Gospel | Standards | Musicals | Specialty | World | Barbershop | Contemporary | Vocal Jazz | Choral | Christmas
Mixed Voices | Female | Male | 8 Parts | 6 Parts | 5 Parts | 3 Parts | 2 Parts | Medleys | Solo | Folio Series | New Releases
Contemporary Vocal Jazz American Standards Choral Barbershop Doo-Wop Gospel Vintage Harmony World Early Music Christian Blues Classical Musicals Country Spirituals Patriotic Christmas A Cappella Recordings Vocal Harmony Groups The Artists The Videos Instructional DVDs Browse Kids
Search for Arranger, Composer, Performer, Director and more!
Find a Song Arrangement
Browse Arrangements


Suffolk Chess: Not long now!
It's nearly time for the British Championships (they start on Friday), which means that the new grades will be published soon. In fact, the Director of Grading is predicting they will be ready tomorrow (Tuesday).
Over the next few days there will be a number of posts that will enable readers to catch up on events over the summer. These include an end-of-season round-up, decisions from the AGM, the Norfolk & Suffolk Cup result (Suffolk section), and Cup & Plate winners.
We are also trying to encourage more players to act as coaches for the promising juniors.
So, first, it should be the new grades. These will assist club secretaries, who need to let the Competitions Secretary know by the end of the month (preferably earlier) of their team entries for the coming season.
If you haven't done so already, make sure you see every new posting on this website by adding your email address and clicking 'submit' (at bottom right of the page).


text:
Q: VBA Excel how to set workbook based on partial name and check if work book is open based on partial name Good Afternoon,
I never used VBA before so I really need your help!
I have following macro (my first ever) and it works fine but after testing with our district managers  this file ("SalesOrderRMTOOL.xlsx") open with different name on their computers.
How can I change my macro to read only a partial name? It will always be SalesOrderRMTOOL but after it could be anything……?? Thank you for your help in advance
Private Sub CommandButton1_Click()
    Dim wsSource As Worksheet
    Dim wsTarget As Worksheet
    Dim wsTool As Worksheet
    Dim wBook As Workbook
On Error Resume Next
    Set wBook = Workbooks("SalesOrderRMTOOL.xlsx")
    If wBook Is Nothing Then
        MsgBox "Please open SaleOrderRMTOOL file"
        Set wBook = Nothing
        Exit Sub
    End If
    Set wsSource = Workbooks("SalesOrderRMTOOL.xlsx").Sheets("Salesorder")
    Set wsTarget = Workbooks("RMORDERTOOL.xlsm").Sheets("Sales Order")
    Application.ScreenUpdating = False
    Workbooks("RMORDERTOOL.xlsm").Sheets("Tool").Range("i7:i1003").Value = ""
    Workbooks("RMORDERTOOL.xlsm").Sheets("Tool").Range("l7:l1003").Value = ""
    Workbooks("RMORDERTOOL.xlsm").Sheets("Tool").Range("o7:o1003").Value = ""
    wsTarget.Cells.Clear
    ' Copy header row to Target sheet if target is empty
    If IsEmpty(wsTarget.Range("A1")) Then wsSource.Rows(1).Copy Destination:=wsTarget.Range("A1")
        ' Define visible filterd cells on source worksheet and copy
        With wsSource
            .Range("A2", .Cells(.Cells(Rows.Count, "A").End(xlUp).Row, .Cells(1, Columns.Count).End(xlToLeft).Column)).SpecialCells(xlCellTypeVisible).Copy
        End With
        ' Paste to target sheet
        wsTarget.Cells(Rows.Count, "A").End(xlUp).Offset(1).PasteSpecial xlPasteValues, xlPasteSpecialOperationNone, False, False

        Application.CutCopyMode = True
        Application.ScreenUpdating = True

        Workbooks("SalesOrderRMTOOL*.xlsx").Close 0

End Sub

A: I would create a short function to return the sales order workbook if it exists. At the top of the module with the function, I'd use a Constant (Const) to hold the beginning of the workbook name, in case it ever changes:
'Constant at top of module
Const WORKBOOK_NAME As String = "SalesOrderRMTOOL"

'Anywhere else in same module
Function GetSalesOrderWb() As Excel.Workbook
Dim wb As Excel.Workbook

For Each wb In Application.Workbooks
    If Left(wb.Name, Len(WORKBOOK_NAME)) = WORKBOOK_NAME Then
        Set GetSalesOrderWb = wb
        Exit Function
    End If
Next
End Function

Then call it like this:
Set wBook = GetSalesOrderWb
If wBook Is Nothing Then
    MsgBox "Please open SaleOrderRMTOOL file"
    Exit Sub
End If

A: You can make the person who will use this macro to select the Workbook he will use displaying a dialog like this:
Sub BrowseWorkbooks()
Const nPerColumn  As Long = 38          'number of items per column
Const nWidth As Long = 13                'width of each letter
Const nHeight As Long = 18              'height of each row
Const sID As String = "___SheetGoto"    'name of dialog sheet
Const kCaption As String = " Select Workbook"
                                        'dialog caption
Dim i As Long
Dim TopPos As Long
Dim iBooks As Long
Dim cCols As Long
Dim cLetters As Long
Dim cMaxLetters As Long
Dim cLeft As Long
Dim thisDlg As DialogSheet
Dim CurrentSheet As Worksheet
Dim cb As OptionButton
    Application.ScreenUpdating = False
    If ActiveWorkbook.ProtectStructure Then
        MsgBox "Workbook is protected.", vbCritical
        Exit Sub
    End If
    On Error Resume Next
        Application.DisplayAlerts = False
        ActiveWorkbook.DialogSheets(sID).Delete
        Application.DisplayAlerts = True
    On Error GoTo 0
    Set CurrentSheet = ActiveSheet
    Set thisDlg = ActiveWorkbook.DialogSheets.Add
    With thisDlg
        .Name = sID
        .Visible = xlSheetHidden
        'sets variables for positioning on dialog
        iBooks = 0
        cCols = 0
        cMaxLetters = 0
        cLeft = 78
        TopPos = 40
        For i = 1 To Workbooks.Count
            If i Mod nPerColumn = 1 Then
                cCols = cCols + 1
                TopPos = 40
                cLeft = cLeft + (cMaxLetters * nWidth)
                cMaxLetters = 0
            End If
            Set CurrentWorkbook = Workbooks(i)
            cLetters = Len(CurrentWorkbook.Name)
            If cLetters > cMaxLetters Then
                cMaxLetters = cLetters
            End If
            iBooks = iBooks + 1
            .OptionButtons.Add cLeft, TopPos, cLetters * nWidth, 16.5
            .OptionButtons(iBooks).Text = _
                Workbooks(iBooks).Name
            TopPos = TopPos + 13
        Next i
        .Buttons.Left = cLeft + (cMaxLetters * nWidth) + 24
        CurrentWorkbook.Activate
        With .DialogFrame
            .Height = Application.Max(68, _
                Application.Min(iBooks, nPerColumn) * nHeight + 10)
            .Width = cLeft + (cMaxLetters * nWidth) + 24
            .Caption = kCaption
        End With
        .Buttons("Button 2").BringToFront
        .Buttons("Button 3").BringToFront
        Application.ScreenUpdating = True
        If .Show Then
            For Each cb In thisDlg.OptionButtons
                If cb.Value = xlOn Then
                    'Store the name of the Woorkbook to use it later
                    SelectedWorkBookName = cb.Caption
                    Exit For
                End If
            Next cb
        Else
            MsgBox "Nothing selected"
        End If
        Application.DisplayAlerts = False
        .Delete
    End With
End Sub

Then use the SelectedWorkBookName variable to call the workbook like this:
Set wBook = Workbooks(SelectedWorkBookName)


Next: What is Office 365?
Find what you need or get help and training with Tell Me.
Use templates to create professional documents.
Express complex ideas and data with SmartArt and Charts.
Collaborate in shared documents whether you're working offline, online, or simultaneously with others.
Work seamlessly anywhere with your favorite Office apps and pick up where you left off on any device.