Excel VBA Find String in Range Return Row Change Background color Remove Duplicates. Get code to perform search operation for a string in worksheet cell range. Also use the same to find duplicates, change cell color based on value, find row of search string …
Excel VBA code to Loop through all Open Workbooks. Also, use the same code to get names of all the open workbooks. This is useful to scan though & get the properties of any number of open workbook in the current system.
Excel to HTML Table Converter App download and also get VBA Macro code that loops through Excel sheet content & convert it into a HTML Table
Excel vba code to choose any Outlook Email Account to send email. Used in Mass email or bulk email services thru Outlook Email. Select from list of Email Accounts configured in your system.
Get VBA code to delete shapes in Excel workbook dynamically. Also, you can choose to delete on the the shape object that meet the criteria
Get code to Extract data from website using vbscript. Also the code can be used to parse the html data obtained from the website using vbs parser.
How to Disable images in Firefox, chrome, IE browsers. Also get Excel vba macro code to disable images in IE. Reopen closed tabs, Restore last active sessions in Firefox, Chrome, IE .,
Copy Active workbook or any workbook from external path using the inbuilt Excel function workbook.savecopyas. Make a Excel workbook copy to new path.
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]