Summary: Our client wanted to extract data from a web portal. We wrote a VBA script to the requested information and store it in an Access database. The example below demonstrates the same technology, but the data is stored in Excel. Edit: 7/23/2017 – An improvement on this solution. Edit: 9/9/2016 – I posted a download […]
Continue readingTag Archives: VBA
Mailmerge without using Microsoft Outlook uses only Excel, VBA, Word, and CDOSys
Summary: Send personalized emails to a list of email addresses and names in Microsoft Excel. Technologies used Microsoft Excel Microsoft Word VBA (Visual-basic for Applications) CDOsys (Collaboration Data Objects for Windows 2000) CDOSys Documentation It’s amazing how poorly documented it is.. but this link has some answers. https://msdn.microsoft.com/en-us/library/ms526318(v=exchg.10).aspx And Dan at Microsoft has several links: […]
Continue readingCustom Reports using Excel and SQL Server from Time Plus payroll software
Technology SQL Server Microsoft Excel Time Plus Payroll Software The Challenge One of our clients needed a custom 401k report. They were manually creating the report using data in canned/available reports. We wrote a custom script to extract the data, pull it into Excel in the format required, and save the file with […]
Continue reading