Codeforexcelandoutlook - codeforexcelandoutlook.com - JP Software Technologies
General Information:
Latest News:
Useful Array Functions for VBA, Part 6 12 Jul 2013 | 04:00 pm
It has been nearly a year since my last post about functions adapted from PHP for use in VBA. Sorry! In this article we'll look at some functions for moving values around inside arrays. Shifting Arra...
Forwarding messages in Outlook 1 Jul 2013 | 04:00 pm
In Foward a message and CC the original recipients, Outlook MVP Diane Poremsky posted some VBA code that shows you how to forward a message and automatically copy the original recipients on the new me...
Save selected messages to MSG files 24 Jun 2013 | 04:00 pm
In Save selected email message as .msg file, Outlook MVP Diane Poremsky shows us how to save selected messages as .MSG files on the local computer. Do people really do this? Nevermind. I think the c...
ADODB Code to Trim Text Fields 20 Apr 2013 | 04:00 pm
In Trim all text fields in MS Access database I posted a method for removing excess spaces from a field in Access. This is a guest post from Dave Braunschweig showing how to do the same using ADODB. ...
Random Data Generator 3.3.0 now available 22 Feb 2013 | 05:00 pm
Random Data Generator has been updated to version 3.3.0. To purchase, visit the RDG homepage. This version features several enhancements, including transient custom lists new fields additional fie...
ShipTrack 4.2.5 now available 4 Feb 2013 | 05:00 pm
For those of you interested in tracking packages in Excel, ShipTrack 4.2.5 has just been released. DHL support has been (re-)added, as well as a few other novelties. Visit the download page to grab it...
2013 State of the Blog 28 Jan 2013 | 05:00 pm
Greetings! It has been a while since I last posted, so I thought I'd provide a short update on what has been happening lately with the site. I haven't spent much time writing VBA. Between the holida...
Use Filters to speed up Outlook macros 24 Aug 2012 | 04:00 pm
If you find that your Outlook macros run slow, your code may benefit from using filters to limit the number of items being processed by a loop. According to the Visual Basic Help in Outlook, filtering...
Run VBA code from Excel workbooks automatically using Windows Task Scheduler 10 Aug 2012 | 04:00 pm
Suppose you want to run some VBA code at specific intervals, maybe every day or every week. Using Windows Task Scheduler we can set up our code to run whenever we want. Step 1: Create Excel workbook T...
Using Named Arguments in VBA 8 Aug 2012 | 04:00 pm
In Passing complex arguments with default values in VBA Bruce Mcpherson isn't sure if you can use named arguments in custom functions. And I quote: Some built in functions allow you to use named argum...
