Preeti's Blog

Author: Preeti

  • Benefits of Apple

    An Apple a Day Keeps Doctor Away !!!

    The most awaited apple season have knocked the market. This delicious, juicy fruit is my favorite hence I would like share with you its benefits through this video Benefits of Apple


    Apples

     

     

     

  • Change Windows Update setting in Windows 10 Technical Preview

    1. Open the Microsoft Registry Editor regedit

    • Go to Start > Run
    • Type regedit in popup box

    2. Navigate to —

    HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\
    WindowsUpdate\Auto Update

    3. Double click AUOptions

    regedit1

    4. Here change the Value data to 2

    regedit2

    5. Click Ok

    This will change the Important Updates setting to — Check for updates but let me choose whether to download and install them (more…)

  • Vba Code For Joining and Spliting

    vba code for join and split

  • VBA Code To Separate Filename From The Path

    Dim fullPath() As String
    Dim wbIndex As Long
    Dim wbName as String
    Dim wbAddr as String

    ‘ Wbaddr holds the full path for example: ” D:\Documents and Settings\Desktop\Preeti\macro\Input.xls”

    fullPath() = Split(wbAddr, “\”) ‘Put  Parts of the path into the array fullPath()
    wbIndex = UBound(fullPath) ‘wbIndex holds the largest subscript
    wbName = fullPath(wbIndex) ‘wbName holds the filename i.e. Input.xls

    Here, through Split( ) we have stored the srings separated by “\”. The UBound( ) gives the maximum subscript value through which we get the filename.

  • Secrets Behind Healthy LifeStyle

    Hello Friends,

    There’s a common proverb –

    If  wealth is lost nothing is lost, but
    If  HEALTH is lost everything is lost.

    But there are 90% people in this world who are suffering from different health disorders. Just turn around and see,  9 out of every 10 persons are contracted with minor ailments like obesity, hair falling, dandruff, pimples, greying of hair at an early age, allergic to pollution, or to water. Another major part of population is affected by fatal diseases. And the credit for this goes to the food we eat. See yourself,  are you fit?obesity

    There can be many common reasons to all these problems, like

    • Eating fast food or processed food such as burgers(barbadi ka ghar), Pizaa ( Jo sehat ko pee jaye).
    • Drinking  soft drinks such as coke, pepsi etcs. These are considered as best toilet cleaners by Swami Ramdev.
    • Not taking enough sleep. Inadequate sleep can result in higher stress levels.
    • Smoking or drinking.
    • Not doing any physical exercise.

    Through this post I want to empower you with the knowledge and tools you need to change your lifestyle today to live healthier and longer.

    No doubt our average life span have increased but its filled with different kind of health disorders. The question is,

    Do you want a quality life and to reach old age free of disability and disease?
    Do you want to  live a healthy life?
    Do you want to be happy and enjoy the life to the fullest?

    If the answers to all these question is yes, then you have come to the right place. This post is provides you the guidelines to  living healthier lifestyle.

    healthy lifestyle

    Guidlines to lead a healthy life:

    Here are some of the tips which I have heard from Swami Ramdev while watching his pranayam on TV :


    1. Its the habit of today’s generation to sleep late at night and get up late in the morning.your sleeping time should be from 10pm-11pm. 6 hours of sleep is enough. So you can get up in the morning by 4am -5 am. If due to your work schedule you have to sleep late then keep on drinking water at night.drink lots of water
    2. Early in the morning when you get up drink 2 glass of warm water in the morning. Those having  acidity should drink  plain water. Don’t drink more than 2 glass as it causes gastic. The water that you drink in the morning to clean your stomach should be drunk fast.
    3. Avoid Junk FoodAvoid eating burgers, pizzas, ice-creams, pastries, soft drinks, buiscuits, chips, kurkure and other junk food. Junk food is very tasty but the bonus which comes along with it ( fat on the stomach ) is too difficult to get rid of.
    4. Increase your intake of fresh seasonal fruits and vegetables. It will bring  glow on your face. They helps to reduce weight faster.Glowing face
    5. The most effective thing is to do pranayam tought by Swami Ramdev on TV. Please practice the following pranayam with a yoga tteacher or you may watch in TV before doing these pranayams. Wrong practice may lead to side affect. In Aastha Channel they show from 5-7.30.
    • Bhastrika Pranayam – Relievs you from depression, stress, anxiety. Respiratory diseases are cured. Lungs becomes strong. Cures migrain.
    • Kapalbhati Pranayam – Very effective for weight loss. Cures any type of stomach problem.
    • Baharya Pranayam – Good for hernia and stomach related problems.
    • Ujjahi Pranaya – This is the only cure of thyroid. Do it 7 – 11 times.
    • Anulom Vilom Pranayam – Cures asthama,  arithritis, sinus, allergy problems, paralysis. I have heard in shivir from people that continous pracitice leads to increase the eye sight. Even the spectacles can be done away with. Ear problems can be cured.
    • Bhramri Pranayam-
    • Udgeeth Pranayam –

  • Patanjali Chikitsalaya and Megastores

    Hi Friends,

    In last one decade, the demand for patanjali products have accelarated. This indigenous brand, led by Acharya Balkrishna, has been a great challenge for many foreign brands. Its a sense of great pride for all our fellow Indians.

    As proclaimed by Baba Ramdev, most of the ailments can be cured by pranayam and yoga asanas only (doing it with right method, correct timing and concentration), however for certain diseases we can take disease specific medicines. One of the best thing about these medicines is that they are made of herbs and do not have any side effect, still one should always take under medical supervision.

    Many FMCG such as skin care, hair care, dental care, food products like biscuits, candy, dalia, flours, sauces, pickels, papad etc.,  aastha pooja essentials, bhajan CDs and DVDs, books and many more products are availble at different patanjali stores.

    One can buy these products online at https://www.patanjaliayurved.net

    Checkout the Patanjali Chikitsalaya and Megastores nearest to your locations from the following links –

    https://www.divyayoga.com/patanjali-chikitsalay/

    https://www.divyayoga.com/patanjali-mega-stores/

  • Macro To Delete Sheets From Workbook


    To delete a sheet from the workbook without the user being prompted for confirmations, here is the code:

    Sub DeleteSheet ( ) 
          Dim SheetName As String
          ‘ deletes a sheet named SheetName in the active workbook
          Application.DisplayAlerts = False
          Sheets(SheetName).Delete
    End Sub


    Macro to delete the default sheets(remember there has to be atleast 1 sheet in the workbook, you cannot delete all.) :

    Worksheets(“Sheet1”).Delete  or Worksheets(1).Delete
    Worksheets(“Sheet2”).Delete or Worksheets(2).Delete
    Worksheets(“Sheet3”).Delete or Worksheets(3).Delete

  • Campus Interview Questions

    Facing interview
    Facing interview

    Hello Friends,

    We all know that the global financial meltdown has reduced the placments this year. Students who are in their final leg of studies or qualified who are looking for placement in reputed organizations should prepare thoroughly for the personal interview rounds. Because these days companies look for candidates having good communication skill besides technical skill.

    You all would be in your best attire but you are judged when you start speaking. Most of the students are selected in written but they get eliminated when they are interviewed. You have to give your best in each round specially in HR. So what are you looking for!!!!!

    Start now.You can visit the link below.The site  includes some of the common questions asked in the HR interview. Go ahead and all the best. 🙂

    www.preetibamrah.com/interview

  • VBA Code To Create A New Excel File By Deleting The Existing File

    Sub CreateFile ( )

    If fso.FileExists(wbAddr + “Output.xls”) Then
            Set wkOut = Workbooks.Open(wbAddr + “Output.xls”)
            Set wkOut = Workbooks(“Output.xls”)
            wkOut.Close
            fso.DeleteFile wbAddr + “Output.xls”
    End If
    Set wkOut = Workbooks.Add
    wkOut.SaveAs filename:=wbAddr + “Output.xls”
    Set wkOut = Workbooks.Open(wbAddr + “Output.xls”)
    Set wkOut = Workbooks(“Output.xls”)

     End Sub

    What The Code Does?

    Each time you execute the program the file,  ” Output.xls” is created if it do not exist otherwise it’s deleted and then created.  In the If part to delete the file I have closed it because any open workbook cannot be deleted. Also before closing I have opened it because a wokbook is closed only when it is open. If the workbook is already open no error will occur if you again open it.   Set wkOut = Workbooks.Open(wbAddr + “Output.xls”)  is done only to make sure the workbook is open before closing it.
     

  • VBA Code To Create An excel File

    Sub CreateNewFile ()

    Dim wkOut as Workbook
    Dim wbAddr as string 
    Dim fso
     ‘wbAddr holds the path where the file needs to be created
     ‘like wbAddr=”D:\VbaCodes” 
    Set fso = CreateObject(“Scripting.FileSystemObject”)
    Set wkOut = Workbooks.Add
    ‘Output.xls is the file to be created. A file or workbook is same.
    wkOut.SaveAs filename:=wbAddr + “Output.xls”
    Set wkOut = Workbooks.Open(wbAddr + “Output.xls”)
    Set wkOut = Workbooks(“Output.xls”)

    End Sub