EncodeDna.com
1,075 FOLLOWERS
EncodeDna.com is an effort to present good, useful articles and codes for programmers, web developers, database designers and beginners. The articles and codes are kept simple and to the point. Free articles, tutorials, source code on Asp.Net, MVC, Angular, Angularjs, WCF, C#, Vb.Net, jQuery, JavaScript, Sql Server, Ms-Excel, WebGrid, GridView, CSS, Crystal Report, Browsers, HTML5, Google API,..
EncodeDna.com
3y ago
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 ..read more
EncodeDna.com
3y ago
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 simple Macro. Read More ..read more
EncodeDna.com
3y ago
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 web form from your Excel worksheet using VBA. Read More ..read more
EncodeDna.com
3y ago
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 worksheet actually exists or not in your current or any other workbook. Read More ..read more
EncodeDna.com
3y ago
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 a button from Excel using VBA. Read More ..read more
EncodeDna.com
3y ago
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 ..read more
EncodeDna.com
3y ago
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 ..read more
EncodeDna.com
3y ago
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 ..read more
EncodeDna.com
3y ago
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 ..read more
EncodeDna.com
3y ago
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 ..read more