I am trying to make a class module compatible with 64 bit Excel. I cant find a 64 bit version of the API below. Can anyone pls help?
Please Login or Register to view this content.
I am trying to make a class module compatible with 64 bit Excel. I cant find a 64 bit version of the API below. Can anyone pls help?
Please Login or Register to view this content.
*******************************************************
HELP WANTED! (Links to Forum threads)
Trying to create reusable code for Custom Events at Workbook (not Application) level
*******************************************************
Usually, but not always you can convert 32 in to 64 bits by adding PtrSafeand and changing long in to LongPtr
Please Login or Register to view this content.
Whilst it's not answering your question directly, can't you just generate a GUID with:
Please Login or Register to view this content.
AFAIK, only the first and second arguments would be LongPtr as they are pointers; the third is just a Long, as is the return value.
Everyone who confuses correlation and causation ends up dead.
Thank you all for your contributions.
Unfortunately I wont be able to test them. The workbook containing the class module is issuing System Error messages and cant be saved. Rather than risk corrupting any other projects, I wont attempt to recover the class. (Instead I restored a backup prior to these changes and have removed this class and any calls to it)
@Kyle - to answer your question - the class module was 'other persons code' - I didn't (don't) know what the module was doing with this API call. (I hesitate to replace working code with an alternative method when I don't fully understand what it is doing)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks