+ Reply to Thread
Results 1 to 5 of 5

64 bit version of API StringFromGUID2

  1. #1
    Valued Forum Contributor
    Join Date
    08-29-2012
    Location
    In lockdown
    MS-Off Ver
    Excel 2010 (2003 to 2016 but 2010 for choice)
    Posts
    1,766

    64 bit version of API StringFromGUID2

    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

    *******************************************************

  2. #2
    Forum Expert
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    Re: 64 bit version of API StringFromGUID2

    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.

  3. #3
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    365 Win 11
    Posts
    7,238

    Re: 64 bit version of API StringFromGUID2

    Whilst it's not answering your question directly, can't you just generate a GUID with:
    Please Login or Register  to view this content.

  4. #4
    Forum Guru romperstomper's Avatar
    Join Date
    11-04-2008
    Location
    A1
    MS-Off Ver
    Most
    Posts
    12,302

    Re: 64 bit version of API StringFromGUID2

    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.
    Remember what the dormouse said
    Feed your head

  5. #5
    Valued Forum Contributor
    Join Date
    08-29-2012
    Location
    In lockdown
    MS-Off Ver
    Excel 2010 (2003 to 2016 but 2010 for choice)
    Posts
    1,766

    Re: 64 bit version of API StringFromGUID2

    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)

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 2
    Last Post: 04-11-2015, 12:44 AM
  2. Get code that works on excel version 2007 to work on version 2010
    By Agent1 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-21-2014, 01:23 AM
  3. MDAC version and ADO version (Run-Time error '430')
    By ccs1981 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-12-2014, 01:48 AM
  4. [SOLVED] Macro to determine version of excel version
    By dare2join in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-17-2013, 01:21 AM
  5. Replies: 3
    Last Post: 06-16-2005, 11:05 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1