Read the output of Execute shell command from VBA in Excel.Issue any function to execute in command prompt thru Shell & read the output to process in VBA
Excel VBA for 64 bit machine & also that is compatible for 32 bit. Get code to declare Windows API functions for 64 bit Office version for VB6 & VB7 editor
Use this method to open vcf file without using any special converter apps. With this method, you will be able to view the complete detail of a vCard file.
Use this VBA code or Excel app to create Email List using Excel. Created distribution list can be used to email to multiple recipients for Marketing purpose
VBA Check If String is Alphanumeric or Not There is no string operator or function in VBA to check if a field has only alphabets. There is worksheet function with name “IsText”. But this function will return “True” even for “IsText( a123)”. In that case, use this function that can… [Continue Reading]
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 to HTML tag using VBA code. A Cell can have single or multiple font formats. This code converts each type to HTML Tag.
Use this simple technique to get free stock market data as an Excel stock price list. Build your own best live stock ticker using this Excel VBA macro code.
How to Automate Emails From Excel? Get macro to send email from Excel & email Excel file as attachment using VBA. In this page, you will learn and get code for 2 different things. Be it a professional Organization announcement, Promotional offer or a Valentine greeting email, these codes will… [Continue Reading]