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 …
Author: Preeti
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 4. Here change the Value data to 2 5. Click Ok This…
Vba Code For Joining and Spliting
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…
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…
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.…
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…
Campus Interview Questions
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…
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…
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…