+ Reply to Thread
Results 1 to 8 of 8

Convert 32Bit to 64Bit

  1. #1
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,882

    Convert 32Bit to 64Bit

    Hello everybody
    I wondered .. is there an easy way to convert the codes that were created on 32 bit to be compatible with 64 bit..
    For example these lines gets error on 64 bit
    Please Login or Register  to view this content.
    How to achieve this task with any declaration??!

  2. #2
    Forum Expert gmr4evr1's Avatar
    Join Date
    11-24-2014
    Location
    Texas
    MS-Off Ver
    Office 2010 and 2007
    Posts
    3,448

    Re: Convert 32Bit to 64Bit

    I think you have to change the "As Long" at the end of the line to As LongPtr. And possibly change the Declare to Declare PtrSafe
    1N73LL1G3NC3 15 7H3 4B1L17Y 70 4D4P7 70 CH4NG3 - 573PH3N H4WK1NG
    You don't have to add Rep if I have helped you out (but it would be nice), but please mark the thread as SOLVED if your issue is resolved.

    Tom

  3. #3
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,882

    Re: Convert 32Bit to 64Bit

    Thanks for the hint
    Is there a code that convert 32 bit to 64 bit? or a function that can do that?

  4. #4
    Forum Expert gmr4evr1's Avatar
    Join Date
    11-24-2014
    Location
    Texas
    MS-Off Ver
    Office 2010 and 2007
    Posts
    3,448

    Re: Convert 32Bit to 64Bit

    Sorry, I was pretty vague with my response.
    Please Login or Register  to view this content.
    You may or may not have to do this with each line.

  5. #5
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,882

    Re: Convert 32Bit to 64Bit

    thanks again
    I read some articles quickly and deuced that before Declare we should use PtrSafe and Long to be LongPtr
    But I noticed some of Long remains as it is , sometimes to be LongLong , and sometimes LongPtr
    That confused me ..
    I wondered if there is a vba code that do that task efficiently?

  6. #6
    Forum Expert gmr4evr1's Avatar
    Join Date
    11-24-2014
    Location
    Texas
    MS-Off Ver
    Office 2010 and 2007
    Posts
    3,448

    Re: Convert 32Bit to 64Bit

    I think the LongLong is just someones way to say that the declaration is extra long, don't use LongLong, use the LongPtr as in the code In post #4. As far as code to do the task efficiently, I assume you mean a code that you can run and it will make the changes for you. If that is what you mean, then I have not seen any code anywhere that will change it automatically....at least not yet.

  7. #7
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,882

    Re: Convert 32Bit to 64Bit

    As for this line
    Please Login or Register  to view this content.
    I found three combinations : which is true?
    Please Login or Register  to view this content.
    Please Login or Register  to view this content.
    Please Login or Register  to view this content.

  8. #8
    Forum Expert gmr4evr1's Avatar
    Join Date
    11-24-2014
    Location
    Texas
    MS-Off Ver
    Office 2010 and 2007
    Posts
    3,448

    Re: Convert 32Bit to 64Bit

    Have you tried them? If none work, try this one....
    Please Login or Register  to view this content.

+ 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. my 32bit vba code won't run in 64bit
    By ncaravela in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-17-2014, 02:15 PM
  2. Change registry settings for IE 64bit in 64bit environment
    By dgdgdg in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-30-2014, 07:56 AM
  3. [SOLVED] GUID code for 32bit to work with 64bit also
    By BJ5352 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-24-2013, 06:59 AM
  4. Replies: 3
    Last Post: 11-23-2012, 01:57 AM
  5. Convert MostRecent Function from 32bit to 64bit (XP>WIN&)
    By bdb1974 in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 02-28-2012, 04:34 PM

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