Download Link: MergeExcel This is the extension of my earlier article “Consolidator“. In this article we will modify it further. Suppose we have a scenario where we have multiple excel files with same columns...
Download Link : Consolidator_1.0 If you want to combine many excel files into one file and you don’t want to do it manually, you have come to the right place. This piece of software...
Description: The Timer() function returns the Number of seconds and MiliSeconds since 12:00 AM. Format: Timer() Example:
TimeSerial() Description: The TimeSerial() function returns the Time type based on the parameters provided (Hours, Minutes and Seconds). Format: DateSerial(Hour,Minutes,Seconds) Arguments: Hour Mandatory Type: Numeric or Any Numeric Expression Between 0 and 23
WeekDay() Description: The WeekDay function takes Date as a parameter and returns a number between 1 and 7, that is the week day of the date provided. Format: WeekDay (strDate [Firstdayofweek]) Arguments: strDate Mandatory...
This tutorial will teach you how to get all the working days or weekdays in a specified date range(excluding Satudays and Sundays), simple but very useful when you have come up with a excel...
User Forms are one of the very important features in Excel Macro. It provides and an interface to the user for interaction with the workbook. It has many controls which makes user’s life easy...
Microsoft Excel has lot of built in formulas like Sin(), Avg() and many more, which we discuss in detail in future articles, but apart from that you can write your own functions which will...
To Automate the Internet Explorer (IE) using Microsoft Excel, say for example you want to login to your gmail account using Microsoft Excel. Please follow the steps mentioned below Steps: Create the object of...
Description: The Application.Wait () function pauses the running code or macro for the time specified and once that time is passed, it returns True value. Format: Expression.Wait (Time) Expression : A variable that represents...
To Maximize, Minimize and Restore Internet Explorer (IE) using Microsoft Excel, follow the steps mentioned below Steps:Create the object of Internet Explorer Make the Internet Explorer visible Navigate to the specified URL Wait till...
To launch the Internet Explorer (IE) using Microsoft Excel, follow the steps mentioned below Steps: Create the object of Internet Explorer Make the Internet Explorer visible Navigate to the specified URL Wait till the...
You can perform various operation on Internet Explorer (IE) using your excel, like Launch IE browser, navigate to specific URL, Click on Images on IE, setting text in input box or web edit and...
Hour() Description: The Hour function takes time as a parameter and returns a number between 0 and 23, that is the Hour of the time provided. Format: Hour(strTime) Arguments: strTime Mandatory Type: Time Time,...
Description: The FormatDateTime function takes date as a parameter and returns the specified formatted date or time. Format: FormatDateTime(strDate[,strFormat]) Arguments: strDate Mandatory Type: Date Date which needs to be formatted.
Description: The Day function takes date as a parameter and returns a number between 1 and 31, that is the day of the month. Format: Day(strDate) Arguments: strDate Mandatory Type: Date Date, whose day...
Description: The DateValue() function converts string to a date and return it. Format: DateValue(strString) Arguments: strString Mandatory Type: String String that needs to convert into date, if year is not provided then it will...
Description: The DateSerial() function returns the Date type based on the parameters provided (year, month and date). Format: DateSerial(year,month,day) Arguments: Year Mandatory Type: Numeric or Any Numeric Expression Between 100 and 9999, values between...
Description: The DatePart() function returns the part of given date based on the parameters provided. Format: DatePart(interval,date[,firstdayofweek[,firstweekofyear]]) Arguments: interval Mandatory Type: String expression The time interval you want as a part of given date
Description: The DateDiff() function returns the specified time interval difference between the two dates provided. Format: DateDiff(interval,date1,date2[,firstdayofweek[,firstweekofyear]]) Arguments: interval Mandatory Type: String expression The time interval you want the difference between two dates.