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
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.
Get VBA code to find the last row or column in a Excel wroksheet. Pass sheetname as parameter and get last row/column returned.
Dream11 IPL 2020 – Points Table – Team Positions
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
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 Zip Directory using Python? – Archive folder
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.