Outlook tasks move-up / move-down by VBA

Try this macro - assumes that you have a contiguous table, with headers, and with the WBS text values in the first column of the table.

Please Login or Register  to view this content.

Hi Bernie - Does this apply to outlook tasks folder? Looks more like it applies to an excel range - which I already know how to do.
Its specifically the part about moving outlook tasks up and down the task list that I'm finding a challenge.

Also, are you sure this accomodates the sorting of 9.8, 9.9, 9.10, 9.11, 10, 10.1, 10.2 correctly? An alphabetic sort will put 9.10 before 9.9, and 10 before 9.x, which isn't correct. This is a WBS - not decimal numbers.

I'm sorry about that. I overlooked the "Other apps" part of the header.

The macro was written for Excel, but will correctly sort an array that is read into it (using an array rather than a range) based on the string WBS values (they are converted to decimal numbers to do the sorting). If you read in an array, this version will sort it and then the array can be exported - the import and export in the example are based on an Excel range, but you could simply read and write the data array of the object of interest.

Please Login or Register  to view this content.