Tuesday, June 23, 2009

Legacy VBA Error - For next loop may really mean If end if.

I was updating some legacy VBA code today and had to add some additional logic to a function. When I click the run button, I was faced with this dialog box
A quick check of the code indicates that there IS a closing "NEXT" statement for the "For Each..." loop. When this happens to you, check any "If...." logic constructs within the "For ... Next" loop. Chances are you'll find a missing "End if" statement.

Labels: , , , , , , , , , ,

# posted by Richard Binning : Tuesday, June 23, 2009 0 comments links to this post

Thursday, March 08, 2007

Daylight Savings Time comes early this year!

If you do nothing else to prepare for the 3 week early Daylight Savings Time adjustment, at least put the date and time in the subject line on any notices, appointments, and/or meeting requests you schedule. During the advance period of March 11th to March 25th, not everyone's calendar will be behaving as expected. Do yourself and those you meet with a favor. Check your calendars frequently and place the date and time of the meeting in the subject line. You'll be glad you did.

DST commonly begins in the northern hemisphere on the last Sunday in March or the first Sunday in April and ends on the last Sunday in October. However, due to the Energy Policy Act of 2005, beginning in 2007, the United States will begin observing DST from the second Sunday in March until the first Sunday in November. (Studies will determine if this remains permanent.)” – Wikipedia

Here are some links to information that will help with your DST adjustments:

Microsoft Discussion
Windows XP (SP2) - KB 928388
Windows XP (SP1) - Not Supported
Windows Server 2003 - KB 928388
Windows 2000 - Apply TZEDIT.EXE manually
Windows NT4 - Not Supported
Microsoft Outlook - Check the Microsoft Download Center
Windows Mobile Devices - Microsoft KB Article 923953
Windows CE - KB 923027

Hope that helps

Labels: , , , , ,

# posted by Richard Binning : Thursday, March 08, 2007 0 comments links to this post