J-Walk & Associates, Inc.

PUP v7.1 Is Coming

Several people have pointed out to me that PUP v7 does not work with 64-bit Excel 2010 Beta.

The problem is with the API function calls.

NOTE: I deleted some of this post because the information is wrong.
See: PUP v71. Revisited.

 Fortunately, it's an easy fix. All of the API function declarations need to be modified by adding PtrSafe between Declare and Function. For example, the declaration that starts like this...

Private Declare Function HtmlHelp Lib "HHCtrl.ocx" Alias "HtmlHelpA" ...

... must be changed so it starts like this:

Private Declare PtrSafe Function HtmlHelp Lib "HHCtrl.ocx" Alias "HtmlHelpA" ...

PUP v7 consists of 87 files, and thirteen of them (including pup7.xlam) need to be modified. 64-bit Excel users can identify these files because you'll get an error message when you try to run the utility contained in that file. If you've purchased PUP v7 with the source code option, you can make the changes yourself, if you're so inclined (make sure you save the file after changing it). Otherwise, just be patient.

I hope to have a new version available within a few weeks a month or so.

The new version (called PUP v7.1) will replace the current version, and it will be compatible with both 32-bit and 64-bit versions of Excel. It will have no other new features, and there will be no charge for current PUP v7 licensed users to upgrade. There's really no reason to upgrade unless you use (or plan to use) the 64-bit version of Excel 2010.

I'm curious... How many of you have tried the 64-bit version of Excel 2010 Beta? Do you plan to? If so, why?