How to create a responsive custom scrollbar using CSS
EncodeDna.com
by
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
Visit website
How to Fill a Web Form from Excel using Worksheet Data and VBA
EncodeDna.com
by
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
Visit website
Web Scrapping – How to fill a Web Form from Excel using VBA
EncodeDna.com
by
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
Visit website
How to check if Worksheet Exists using VBA Macro
EncodeDna.com
by
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
Visit website
Insert an object in Outlook Created from File and Display as Icon from Excel using VBA
EncodeDna.com
by
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
Visit website
SQL Server - Convert Rows into Columns and save data in a Table
EncodeDna.com
by
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
Visit website
Excel VBA to find Matching records between two Ranges
EncodeDna.com
by
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
Visit website
Get the First and Last Day of a given Month in SQL Server
EncodeDna.com
by
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
Visit website
How to Auto-refresh DIV every few Seconds using JavaScript and Ajax
EncodeDna.com
by
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
Visit website
JQuery Cascading SELECT dropdown using JSON data
EncodeDna.com
by
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
Visit website

Follow EncodeDna.com on FeedSpot

Continue with Google
Continue with Apple
OR