Excel VBA – Get Extended File Property – Author Modified Date Time
Get code to read Excel File property like Author, Last modified date, File size etc., Also has code for reading file of any type from your computer folder.
Excel Import Data – From another Workbook – Query External Source
Learn how to make Excel import data from another workbook using Microsoft query method in simple steps. Also learn external reference data import techniques
Convert a Formatted Cell in Excel into HTML Tag using VBA
Convert a formatted cell in Excel to HTML tag using VBA code. A Cell can have single or multiple font formats. This code converts each type to HTML Tag.
Palindrome program in C & VBA
Learn how to code a Palindrome program in C that can check for both numeric palindrome and string palindrome. Page has 2 different function for palindrome.
C Program to find Prime Numbers List & in VBA Too
Get C program to print prime numbers list using while loop. Program prints all the prime numbers from 1 to 100 or even any range. Simplest Prime number pgm.
Learn How To Code JavaScript in VBA
Learn how to execute a Javascript within a VBA Code? It is not that tough to code a Javascript within VBA and make it execute within Excel itself. All you just have to do is, reference Microsoft Script Control Library and start coding your Javascript or VBscript as explained in this page.
5 Amazing Productivity Tools That Extends Your Free Time
Make Your Free Time Last Longer With These Productivity Tools Nowadays it is common that we strive to do the most work in the least amount of time. With the constant progress of information technology, we have more help with that than we ever did. But it’s not easy to… [Continue Reading]
Software Downloads From Our App Store – Try Free & Buy
Download Great Apps at Very Low Prices Note: Indian Users can buy products from this link. International Users can buy from below links. Please note the the app is not Open Source. Only the app is sold for usage & source code will not be provided. Contact us for any… [Continue Reading]
Excel VBA – Import Data from Another Workbook – Macro to Query Excel
Excel Import Data From Another Workbook – VBA Codes To pull data from an external Excel file, use on of these scenarios. Closed Excel file: Using VBA Import data with Workbook object Opened Workbook: Using VBA Read Excel file. External Reference within Worksheets. ODBC Data Import from another workbook. Excel… [Continue Reading]
Removing Empty Folder is Now Easy – Get Folder List with Size
Fully Functional code that can fetch you folder list along with its size. This helps ur to find empty folders in our system. Once we get the list, we can remove the empty folders and on the other hand if the folder size is so huge, we can dig in and find why it’s size is so much huge.
