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 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]
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]
Quick Guide to copy visible cells only in Excel sheet range. Get VBA Macro code also to select the Visible cells, copy and paste them to a target worksheet. This article explains the manual methods and also has VBA macro to do the same.
Get free VCF to Excel & Excel to Vcard converter. Just download this app, input your file detail & convert from VCF to Excel or Xls to Vcard.
In Excel VBA or any programming language we have built in function to generate random number. With these functions there are possibilities that the function can generate same number any number of times. There is no limitation set on these functions. With the code in this article, we can generate… [Continue Reading]