atlas news
    
EncodeDna
05  mai     12h44
How to create a responsive custom scrollbar using CSS
   Not every page on my blog, but this particular page has a custom scrollbar. Look at the scrollbar carefully. Yes, its different from a default scrollbar. Its a custom designed scrollbar. I’ll show you how to create a cool responsive custom scrollbar using pure CSS. Read More
23  avril     20h27
How to Fill a Web Form from Excel using Worksheet Data and VBA
   In my previous article on Excel automation using VBA, I have explained how to fill a web form and save data from Excel using VBA. The data that I have used in that example were hardcoded. Now, in this post, I’ll show you a more dynamic process by using worksheet data to fill a web form using a...
18  avril     21h57
Web Scrapping - How to fill a Web Form from Excel using VBA
   Web scraping is a process where an application extracts data or content from a web page. You can do this from your Excel worksheet using VBA. I have shared an article here before where I have explained how to extract data from HTML elements using a Macro. In this post, I’ll show you how to fill a...
12  avril     20h24
How to check if Worksheet Exists using VBA Macro
   While working on worksheets using a macro, you may sometimes need to know if a particular worksheet exists in a workbook or not. Especially, when the worksheets you are working have random names. You either have deleted it or renamed it. I’ll show you how using a macro, you can easily check if a...
30  mars     13h22
Insert an object in Outlook Created from File and Display as Icon from Excel using VBA
   You can insert a variety of objects like Excel workbook, PDF or Word document, images etc., in your email message using Outlook any version , by clicking on various tabs, buttons and options. Or, you can automate this entire process. I’ll show you how you can do this dynamically with the click of...
15  mars     13h24
SQL Server - Convert Rows into Columns and save data in a Table
   In SQL Server, you can use PIVOT to convert multiple rows into columns to show a summarized result. I’ll show how using this method you can easily save the rows to columns converted data into a table in SQL Server. Read More
22  février     11h57
Excel VBA to find Matching records between two Ranges
   Let us assume, I have two ranges of values in my Excel worksheet. Each range has two columns each region and sales . Now, both the ranges have some common regions. How do you find the matching records the regions in particular between both the ranges using VBA Read More
   
Get the First and Last Day of a given Month in SQL Server
   In SQL Server, you can use the DATENAME function to get the week day for a given date. I’ll show you how to use this function to get first and last day of a given month or date in SQL Server. Read More
16  février     12h44
How to Auto-refresh DIV every few Seconds using JavaScript and Ajax
   Let us assume, your web page has a DIV element and you want to auto refresh its contents every few seconds. You can easily do this using jQuery or any other library. I’ll show how to auto refresh a DIV every few seconds using plain JavaScript and Ajax. And its very simple. Read More ...
02  février     12h50
jQuery Cascading SELECT dropdown using JSON data
   A cascading dropdown list or a dependent dropdown list gets data from a data source based on a value selected from another dropdown list. I’ll show you how to create a cascading SELECT dropdown list using JSON data and jQuery. Read More
20  janvier     20h46
Merge Multiple Excel Files in Single Workbook but Different Sheets using VBA
   Let us assume, you receive sales data or any data from different regions or zones in multiple Excel files, via email or any other source. Now, you want to merge all the Excel files into one single workbook but in different sheets. I’ll show how easily it can be done using VBA. Read More ...
15  janvier     13h36
How to Add Element to body using JavaScript
   You can use the .appendChild method in JavaScript to add or append an element to the body section of the document or the web page. Read More
12  janvier     13h57
How to get File Size in Asp.Net using C# and VB
   In Asp.Net, you can use the FileInfo class in both C and Visual Basic , to get the file size. This class provides the necessary methods and properties to deal with files. Here in this post, I am sharing few examples in C and VB, explaining how to use the FileInfo class to get the file size. ...
14  décembre     12h14
JavaScript Ajax POST and GET method Example
   Ajax, as you know stands for Asynchronous JavaScript and XML, which allows web applications client side to send and receive data from a server, asynchronously. Ajax can be used with any framework or library like jQuery. You can even use Ajax with plain JavaScript. In this post, I’ll show you how...
01  décembre     21h19
How to add important Style Property using jQuery
   I have previously shared few examples here on my blog that explained how to add or override the important property dynamically in JavaScript. Now in this post I’ll show you how to add the CSS important property to an element dynamically using jQuery. Read More
   
Send email from Excel to Multiple recipients using VBA and Outlook
   Its very common for Excel users to send emails to a list of contacts. Here in this post, I’ll show you how easily you can send emails to multiple recipients from your Excel workbook with the click of a button using VBA and Microsoft Office Outlook. Read More
11  septembre     11h42
How to write Data to a Text file using Excel VBA
   I am sharing a simple VBA macro here that shows how to write data to a text file a .txt file in Excel. Read More
08  septembre     13h41
How to get SPAN tag inside li using jQuery and JavaScript
   In today’s post, I am sharing a quick tip showing how to get span element inside an li tag using jQuery and JavaScript. Let’s assume, I have an unordered list on my web page and inside each li tag, I have span element. How do I get the span elements and its contents using jQuery or JavaScript Let...
01  septembre     12h24
How to Create Smooth Scrolling using jQuery
   We often use the hash within the href attribute of HTML anchor tag to link to a particular section in a web page. For example, to scroll to the top of the current page you can use href top and href bottom to scroll to the bottom of the page. Clicking a link, with the will instantly take...
   
Input File change event not working
   I recently noticed a bug in my Bulk Image Resizer tool. The file input was not working or not selecting files after clearing the existing selections and selecting new files images . The issue is now resolved. After investigating the script, I found both onchange event and the jQuery change event...
24  août     17h28
Convert your Form Data to PDF using JavaScript
   In this article, I’ll show you how to convert your form data into a PDF using only JavaScript. Not just plain text data, the example also shows how easily you can convert an image on your web form into a PDF file. Read More
16  août     21h12
Create Line Charts with Highcharts using jQuery Ajax and Asp.Net Web Service
   I shared an article on Hightcharts a few days back where I have explained how to create Column charts with Highcharts API dynamically using JSON data extracted from a remote file. You can use any data source for the charts and here I am sharing an example on how to create a basic Line Chart with...
10  août     12h34
Create Column Charts using Highcharts API with data Extracted from External JSON file
   Highcharts is a pure JavaScript library, which provides easy to use methods and properties to create interactive and animated charts for your websites and web applications. It supports many different chart types like the bar, pie, line, column and many more. Here I am sharing an example showing how...
04  août     09h46
Where to Find the List of your YouTube Subscribers
   My year old son recently created a YouTube channel for my year old father his grandpa . The channel name is Mee and Grandpa. My father is an Indian Navy Veteran Ex. Pioneer Submariner and he is a poet. He writes stories and poems in Bengali Language. So, my son decided to create a channel,...
02  août     21h01
How to Remove Empty Slots in JavaScript Arrays
   I remember using the filter method once to remove empty slots in an Array in JavaScript. An empty array slot might look like this ... const arr , ,,, , ; integers and are missing and to remove these slots you can use arr.filter x x . There is a better way to do this,...
29  juillet     14h11
Override important Style Property in JavaScript
   We often use the important property in CSS to ignore the rules or styles applied to an element and instead apply rules that has important property. You can further override the important rules using inline style or dynamically. I’ll show you how to override the important style rules using...
22  juillet     13h31
How to get values from Cloned Input Fields in jQuery
   In jQuery, you can use the .clone method to clone a textbox or an input field on your web page. You can clone the textbox with or without the values. Since, these cloned fields are dynamically created, at runtime, retrieving the values from these input fields can sometimes be challenging. I’ll...
08  juillet     18h30
Connect and Pull data from SQL Server database in Excel using VBA
   You can use Excel as a database, as long as your requirements are limited. Create multiple sheets in your workbook, store various type data in the sheets and work with the data as and when required. However, sometimes this is not enough and you’ll need an RDBMS like SQL Server to store data. Here...
01  juillet     21h30
SQL Query to Get Last 3 Months Records in SQL Server
   In SQL Server, you can use the DATEADD function to get last months or n months records. I have used this function in one of my previous posts where I have shown how easily you can get previous month records from the current month. Here in this post I’ll show you how to get last months...
15  juin     16h01
How to Search an Array in JavaScript like SQL LIKE Statement
   If you have worked with SQL, then I am sure you must have come across the LIKE statement to search a specified pattern in a table. The LIKE in SQL uses a percent sign to fetch a pattern of values. You can do something similar in JavaScript to search or filter values from an Array using few...
08  juin     14h03
Excel Macro to Pull Data from another Workbook
   I am sharing three simple methods here, which shows how to pull or read data, as it is, from another Excel workbook, in your computer or from a remote computer. While pulling or extracting the data, the source file can be in close or open state. Read More
29  mai     12h43
Automatically add One Month from Previous Date in Excel
   In Excel, you can use the EDate method to automatically add one month from the previous date or increment the previous date by one month. Read More
27  mai     11h07
How to remove commas from an Array using a one line code in JavaScript
   You can use the join method in JavaScript to remove commas from an array. The comma delimiter in an array works as the separator. For example, let arr ’alpha’, ’bravo’, ’charlie’ . Using the join method, you can remove or replace all the commas with a space. Read More
22  mai     09h40
How to Embed YouTube Video in a Webpage without IFrame
   There are many ways you can embed a YouTube video in a web page without IFrame. Although, the iframe is the recommended method for YouTube embeds, if however, you do not want to use iframes, you can use the HTML embed element or the object element to embed YouTube videos. Read More ...
19  mai     13h08
How to trap VLOOKUP #N A errors with IFERROR in Excel
   You must be familiar with VLOOKUP function and the error N A, which the function often throws when it fails to find a lookup value. It can be annoying at times, since N A does not explain the error clearly. I’ll show how to trap VLOOKUP N A errors with IFERROR method to explain the errors in...
12  mai     13h53
How to read data from External JSON file in JavaScript
   There are many ways to store JSON data for your application. You can store JSON in an array or in an external file. There are many ways to read JSON data from external files. I have previously shared a jQuery example and now here in this post I’ll show you how to read and extract data from an...
06  mai     09h07
How to get only the FileName from Url in JavaScript
   A URL or a web address, often has a file name, with few parameters occasionally. Sometimes, we might need to know only the file name in the URL. There’s a simple technique to extract the file name from a url in JavaScript. Read More
04  mai     18h02
How to Export GridView data to Ms-Word in Asp.Net
   You can use the DataGrid control in Asp.Net to export GridView data to an Ms Word document. I am sharing codes here, both C and Vb.Net, which explains how easily you can export data extracted from a paging enabled GridView to an Ms Word doc file. Read More
    10h07
The correct formula to Calculate Sales Percentage in Excel
   There’s a simple division formula that you can use to calculate the sales percentage in Excel. Let us assume you have a list of items and number of items sold in a given period. Now, you want to calculate the sales percentage of the items. Read More
29  avril     18h05
How to Change element Class Name using JavaScript
   There are many ways you can change the class name of an element using JavaScript. The classList property in JavaScript is now commonly used. However, classList property and its methods are available in new modern browsers. If you were looking for a cross browser solution, then I would recommend the...
28  avril     12h58
Create ul and li elements dynamically using JavaScript
   HTML ul and li elements are often used to show a list of items with bullet points on a web page. You can add these elements at design time and dynamically at run time. I’ll show you how you can create ul and li elements dynamically using JavaScript. Read More
   
How to select the second Child element inside Parent element using only CSS
   You have a list of elements inside a parent element and you want to select the second element only, for some reason, using only CSS. How will do that Its simple. You can use the CSS :nth child selector to select a particular element or the nth element, inside its parent element. Read More...
14  avril     14h43
Merge multiple Rows in one Cell repeatedly in Excel using VBA
   Here’s a scenario. You have a list of product and the details of each product are entered in different or more rows in a sequence. Now, how do merge all the data in different row into one single cell, repeatedly I’ll show you how using a simple VBA macro you can merge or more rows into a...
13  avril     09h39
Count Total Number of Characters in a Cell in Excel
   You can use the LEN function in Excel to count the total number of characters in a cell in your worksheet. The LEN or the length function takes a parameter or argument , which can be a string or address of a cell. Read More
08  avril     10h26
Redirect Page after a Delay using JavaScript
   You can use window.location.href property to redirect or open a page from your JavaScript code. If you want to redirect a page automatically after a delay then you can use the setTimeout method in JavaScript and it will call the above property after a time delay. Read More
06  avril     21h08
How to reorder HTML P element using CSS
   I have previously shared a post on Flexbox property in CSS that explained how you could reverse the order of HTML elements. Here, I’ll show you how to reorder HTML elements like the P element using the CSS order property. Read More
    10h50
How to align Placeholder text using CSS
   The HTML placeholder attribute is used to show a small hint to describe a value to help users understand what value they should enter in a text field. The placeholder text by default is left aligned. I’ll show you how using CSS, you can align the placeholder text anywhere you want in a text box. ...
25  mars     20h41
Check if Browser is Online or Offline in JavaScript
   You can use the navigator .onLine property in JavaScript to find out whether your browser in online or offline. It actually gives you status of your internet connection. Read More
23  mars     13h10
Difference between clientHeight and offsetHeight Property
   You can use the clientHeight property to measure the inner height of an element, including padding. However, it will exclude the borders, margins and scrollbar height of the element. The offsetHeight property will measure the visible height of an element in pixels, including padding, borders and...
18  mars     11h20
How to use VLOOKUP function with IF Statement in Excel
   A VLOOKUP function also known as the Vertical function in Excel, is often used to look up or find a value from a range of data in a worksheet. I’ll show you how you can use the VLOOKUP with the IF statement, if the result is based on certain conditions. Read More