VBA Loads a XML file into a Excel Sheet An XML file is like a simple text file but structured in a predefined format using tags. Sometimes you need to view an XML file and do calculation on the data using Excel. The code below is used to open an […]
Excel VBA Code to Checks if File Exists in Path
November 21, 2024
Finding an existing file & its path using Excel VBA When writing Excel VBA code that works with external files like XML or JSON, it is important that you have controls in your code to check it the file exist. If your macro (VBA program) doesn’t find a file when […]
VBA To Find Last Row or Column in a Excel Wroksheet.
November 21, 2024
Get VBA code to find the last row or column in a Excel wroksheet. Pass sheetname as parameter and get last row/column returned.
VBA Convert Excel range to JPG Image
November 21, 2024
Get VBA code to convert Excel range to a image file.
Dream11 IPL 2020 – Points Table – Team Positions
November 21, 2024
DIPL2020 Points Table – Season 13 – Dubai Let’s see how the points table stands now. Pos Team Pld Won Lost Tied N/R Net RR Pts Q Mumbai Indians MI 14 9 5 0 0 1.107 18 Q Delhi Capitals DC 14 8 6 0 0 -0.109 16 Q Sunrisers […]
IPL 2020 Points Table PDF – Winners List
November 21, 2024
IPL 2021 Points table Note: Click on this link to get latest points table for IPL 2021. Dream 11 – IPL 13 2020 Points Table IPL13 is proving to be tougher than any other season. New teams are coming up at the top of the points table. It’s only the […]
How to define and assign values to JavaScript arrays.
November 21, 2024
Array in JavaScript Arrays are variables that can store ordered collection of values in them which can be of different data types, with each having a numeric position known as an index. JavaScript follows a zero-based indexing scheme, meaning the index of the 1st element will start from 0, 2nd […]
[JS] How to remove particular element in JavaScript Array?
November 21, 2024
JavaScript to Remove Element in Array JavaScript arrays are variables that can store ordered collection of values in them which can be of different datatypes, with each having a numeric position known as indexes. We can add and remove array elements in several ways. So, how do we remove a […]
How to Zip Directory using Python? – Archive folder
November 21, 2024
Archive or Zip all files in Directory The code in this page will Zip directory full of files. It will first get folder path as input. Then loop thru the directory & its sub-directories to get all the files list. Then each file in the list is added to the […]
How to run Exe from Python – 3 Easy methods?
Learn how to run exe using Python program with few of the easy methods available. One is subprocessa nd other is directly using OS Library.