Power Utility Pack (PUP 7)

[StuLux]

I've been using John Walkenbachs Power Utility Pack on and off for several years and purchased access to the code. I've recently switched to 64 bit as I maintain a large and complex Excel 'system' and find it simply runs better and more reliably in 64 bit. I'm having problems getting PUP 7 to work in 64 bit. I've followed the guidance in this post Mr Excel Post and changed the declarations to 'PtrSafe' and the code compiles with no errors after doing this.

The problem I'm encountering is that, whenever I try to use any of the tools in PUP, I get an error saying that PUP cannot find a related file (the PUP tool installs to a folder with about 90 seperate files). I've checked and the files do exist but it seems that the add-in can't 'see'' them. Any ideas?

 

[rlv01]

It's working fine under 64bit for me. I use it all the time. Have you re-run the installer? Because it sounds like an install issue. You're not trying to do something exotic are you? Like trying to run it from a OneDrive folder.

 

[StuLux]

It's working fine under 64bit for me. I use it all the time. Have you re-run the installer? Because it sounds like an install issue. You're not trying to do something exotic are you? Like trying to run it from a OneDrive folder.

Thank you for your response. I do have PUP7 installed on One Drive, I've not had any problems with this before, but I'll try installing it to the C: drive to see if this resolves, thank you for taking the time to offer your thoughts.