+ Reply to Thread
Results 1 to 4 of 4

Declaration solution supported in 32/64 bit environment

  1. #1
    Forum Contributor
    Join Date
    05-13-2019
    Location
    Halifax, Canada
    MS-Off Ver
    2016
    Posts
    176

    Declaration solution supported in 32/64 bit environment

    Hi Experts/Gurus,

    I had following codes for 32 bit environment:

    Please Login or Register  to view this content.
    My platform is upgraded to 64 bit however, my colleagues who access reports work in 32 bit environment.

    What will be the alternate declaration that would support both 32 bit and 64 bit environments?

    Thank you
    Roshan

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,603

    Re: Declaration solution supported in 32/64 bit environment

    Looks like this is what you need: https://www.instantexcel.com/text-to...ice-365-64-bit
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Forum Expert
    Join Date
    11-24-2013
    Location
    Paris, France
    MS-Off Ver
    Excel 2003 / 2010
    Posts
    9,831

    Arrow Re: Declaration solution supported in 32/64 bit environment


    Quote Originally Posted by Roshan.Shakya View Post
    What will be the alternate declaration that would support both 32 bit and 64 bit environments?
    Hi, for old standard data types just adding PtrSafe statement for both environments like in this sample

  4. #4
    Forum Expert romperstomper's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    365, varying versions/builds
    Posts
    21,274

    Re: Declaration solution supported in 32/64 bit environment

    Quote Originally Posted by Marc L View Post
    for old standard data types just adding PtrSafe statement for both environments
    But that is not sufficient here since window handles are involved, which need to be declared as LongPtr rather than Long.
    Remember what the dormouse said
    Feed your head

+ 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. [SOLVED] Method not supported error
    By UltimateNeo in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-01-2019, 09:23 AM
  2. File not supported in MAC!!!!
    By meus in forum Excel General
    Replies: 6
    Last Post: 07-17-2015, 04:52 AM
  3. [SOLVED] Join Expression Not Supported
    By mcranda in forum Access Tables & Databases
    Replies: 1
    Last Post: 02-16-2015, 05:33 PM
  4. [SOLVED] Help in using function supported by an apple app
    By Khaldon in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 08-19-2013, 07:07 PM
  5. List of File Formats that are Supported in
    By ExcelTip in forum Tips and Tutorials
    Replies: 0
    Last Post: 11-08-2007, 03:26 AM
  6. OnAction with arguments supported
    By RB Smissaert in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-14-2006, 10:10 AM
  7. [SOLVED] Sent to printer - Resolution not supported.
    By clueless in forum Excel General
    Replies: 0
    Last Post: 05-11-2005, 12:06 AM

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