Copy Active workbook or any workbook from external path using the inbuilt Excel function workbook.savecopyas. Make a Excel workbook copy to new path.
strftime For quick syntax & options help with this function, type >>help (“time.strftime”) . This will list all the basic help that you are in need. If you are looking for a much more advanced option with this function, then refer this table. About this function: This function is used to… [Continue Reading]
Get 100 Cryptocurrency Price Ticker in Excel. Also download this Excel Ticker with price index for all Cryptocurrency including Bitcoin, Litecoin, Ethereum.
Add this script to your website to display the Bitcoin Trading performance chart, current price, News, discussions etc., It just takes 2 mins to add it.
Get the list of best Bitcoin Trading platforms available in the internet now & learn how to buy/sell bitcoin and other such cryptocurrencies.
Get JSON Parser in Python that converts JSON to csv or Excel. Sample JSON file is also provided. Code parses JSON by each node & write to CSV file.
Get Historical Stock Quotes – Google Finance Historical Stock Quotes are required as a first data item when you considering buying a stock. Lets say you are investigating GOOG stock listed in the NASDAQ Stock Exchange. You can download the Historical Stock Quotes to Excel using Google Finance with the… [Continue Reading]
JSON Parser. Get VBA macro code to convert JSON to Excel. This code will Parse JSON fields one by one to a dictionary variable.
Create Excel Org chart or hierarchy table from employee reporting data. Here is the free VBA code to do build this Organization tree in Excel.
Excel VBA Dir – Directory Listing – All Subfolders Just input the Root folder path for this Macro. It will fetch all the subfolder & folders under subfolders till its last child folder. It is a complete code that will be used to search or process all the files in… [Continue Reading]