Free Excel template for harvesting email ids with explanation on the process of how to collect Email Ids from a text content or webpage. With this software, Email address list can be generated that can be used for business email marketing or mass mail communication. Use this ready to use code and template.
Import Mail IDs from Outlook Email to Excel
Fetch Email Addresses – Quick Install & Test Code Open MS Outlook and Select any mail in Inbox or any other Folder Open new Excel Workbook, Alt+F11, Copy Paste the code in this Article In Excel VB Editor go to Tools->References->Add Microsoft Outlook nn.n Object Library Press F5. Also Read: […]
How to use Excel VBA Telnet To Autorun Commands?
Using Excel VBA Telnet to create a telnet session from Windows machine & autorun commands. With Excel VBA, telnet sessions can be established automatically.
VBA Code – Create Index of Worksheets – with Links to each Sheet
Vba code to create list of worksheet names with hyperlinks. Once you create this Worksheet Index using vba code, it is easy to refer the sheets. Also display worksheet list tab with macro
How to Delete Blank Rows in Excel – Remove Empty Rows – 3 Easy Tips
How to remove blank rows in Excel & Get Tips to delete blank rows in Excel 2016 or below with build in option. Also Get Excel VBA Delete empty rows Addin.
Making SORT More Simple and Faster in Excel with Advanced Options
Usual Sorting of Data or Table in Excel To Sort a Column Data in Excel, the user has to select the data range or column and then choose option “Sort & Filter”. From here, they can choose either “Smallest to Larger or A to Z” or “Largest to Smallest or […]
Post to Facebook Timeline through Email
Just send a Email to this Mail ID found in FB Settings & Update your Wall without Logging into Facebook. Message in Email Subject appears in Timeline Page.
Login to Facebook, Twitter, Google+ in IE from Excel
Get VBA Code to automatically login into any of your online form or social media like Facebook, Linkedin, Twitter etc., It uses IE along with VBA automation
VBA Download File from URL – using Excel Macro
Using VBA download file from URL – Website link using Excel Macro. Get fully functional VBA code to download file from website.
Extract URL Links from Sitemap.xml file using Excel
About Sitemap.xml Sitemap XML file is used by the search engines to find out the complete list of the pages of the website. Along with url link of the page, it also contains other metadata like last modified date, change frequency(monthly/daily), etc.. This information is vital for the search engine […]