Results 1 to 3 of 3

update 32bit vba to 64bit

Threaded View

  1. #1
    Forum Expert nigelog's Avatar
    Join Date
    12-14-2007
    Location
    Cork, Ireland
    MS-Off Ver
    Office 365 Windows 10
    Posts
    2,286

    update 32bit vba to 64bit

    Hi
    office had to be reinstalled due to problems and the following code used to run a userform minimizing button has thrown an error stating code has to updated to 64bit

    Is this possible??

    Private Declare Function FindWindowA Lib "USER32" _ 
    (ByVal lpClassName As String, _ 
    ByVal lpWindowName As String) As Long 
     
    Private Declare Function GetWindowLongA Lib "USER32" _ 
    (ByVal hWnd As Long, _ 
    ByVal nIndex As Long) As Long 
     
    Private Declare Function SetWindowLongA Lib "USER32" _ 
    (ByVal hWnd As Long, _ 
    ByVal nIndex As Long, _ 
    ByVal dwNewLong As Long) As Long 
     
    Option Explicit 
     
    Sub FormatUserForm(UserFormCaption As String) 
         
        Dim hWnd            As Long 
        Dim exLong          As Long 
         
        hWnd = FindWindowA(vbNullString, UserFormCaption) 
        exLong = GetWindowLongA(hWnd, -16) 
        If (exLong And &H20000) = 0 Then 
            SetWindowLongA hWnd, -16, exLong Or &H20000 
        Else 
        End If 
         
    End Sub
    any pointers appreciated
    Last edited by nigelog; 07-31-2017 at 10:20 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Using Datepicker in Userform VBA compatible to Excel 2013 64bit and 2007 32bit
    By ashburnadam in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 03-29-2019, 03:35 PM
  2. Excel 64bit 2016 Database Connection 32bit...what to do?
    By unclejemima in forum Excel General
    Replies: 1
    Last Post: 03-10-2017, 05:32 PM
  3. Convert 32Bit to 64Bit
    By YasserKhalil in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 01-10-2015, 07:42 PM
  4. 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
  5. [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
  6. Replies: 3
    Last Post: 11-23-2012, 01:57 AM
  7. 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