If you are a
regular user of Excel and deal with lot of text data, then mastering text
functions in Excel is crucial. Excel has in-built text functions to help
cleansing data for you. Below are some the text functions in excel helpful for quick
data cleansing
1.CLEAN: CLEAN function...
How to create user-defined functions in Excel
in formulas
with
No comments
Excel allows users to create custom functions. This enables user to extend the functionalities of Excel. In the below example, a Boolean function created to accepts a cell as a parameter and returns TRUE if the cell has color FALSE if the cell doesn't have any color. Let us call this function...
How to make any file read-only using VBA?
in VBA
with
No comments
VBA has in-built function SetAttr to change attribute of a
file or folder. This Function is classified as File or Directory function.
Below is the syntax of SetAttr and it takes two parameters.
Syntax: SetAttr (FilePath, Attribute)
FilePath is the fully qualified path of the file and
Attribute is the parameter of a file which you wish to change. In this example...
How to add line break and tab space in outlook using VBA?
in VBA
with
No comments
When working on email automation in Outlook, the content of the mail can be of type Body or HTMLBody. Depending on the type we select we can use html tags or VBA constants to add Line Break or Tab Space in the body of the mail.
Line Break:
Assume MailObj is the Outlook mail object. To add line break between two texts in the body of the mail we can use either VBA constant (vbCrLf) or html tag (<br/>)...
How to convert mailing list in Excel column into a string using Collections?
Let us assume you have say 20 email Ids in an Excel sheet to which a common mail communication is to be sent. One way of combining all the emails into a string is using CONCATENATE function. However it is difficult if the no. of email IDs to be combined are more. Another way to accomplish this is by using Collections in VBA. Collections are nothing but group of related objects.
First store all...