+ Reply to Thread
Results 1 to 3 of 3

64bit Version

Hybrid View

plasma33 64bit Version 12-29-2014, 01:46 AM
cytop Re: 64bit Version 12-29-2014, 04:35 AM
plasma33 Re: 64bit Version 12-29-2014, 06:06 AM
  1. #1
    Forum Contributor
    Join Date
    06-20-2011
    Location
    Auckland, NZ
    MS-Off Ver
    Excel 2013
    Posts
    165

    64bit Version

    hi guys,

    how to make the following 32bit version code work in Vba7 Win64 bit version. the code is as follows:

    Private Declare Function SHChangeNotify Lib "Shell32.dll" (ByVal wEventID As
    Int32, ByVal uFlags As Int32, ByVal dwItem1 As Int32, ByVal dwItem2 As Int32) As
    Int32
    thanks guys...

    best regards
    plasma33
    Last edited by plasma33; 12-29-2014 at 06:07 AM.

  2. #2
    Forum Expert
    Join Date
    02-14-2009
    Location
    .
    MS-Off Ver
    ................
    Posts
    2,840

    Re: 64bit Version

    Int32 is not a VBA datatype - probably lifted from a Visual Basic program listing. It may help if you realise that Int32 is called a Long in VBA... And, as none of the parameters refer to a Handle, the declaration will probably convert sucessfuly with the simple change of type.

    (tested - it does)
    Last edited by cytop; 12-29-2014 at 04:39 AM.

  3. #3
    Forum Contributor
    Join Date
    06-20-2011
    Location
    Auckland, NZ
    MS-Off Ver
    Excel 2013
    Posts
    165

    Re: 64bit Version

    thanks for your response cytop...yes you are right...i did what you suggested and its working all good...

    thanks again, cytop.

    best regards
    plasma33

+ 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. Reporting from Excel 64bit using VBA
    By Bezzie in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-22-2013, 02:45 AM
  4. Replies: 3
    Last Post: 11-23-2012, 01:57 AM
  5. very slow copy in Win 7 64bit
    By chuckmg in forum Excel General
    Replies: 1
    Last Post: 12-03-2010, 04:14 AM

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