+ Reply to Thread
Results 1 to 5 of 5

Change User 32 to User 64

  1. #1
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    7,014

    Change User 32 to User 64

    .
    I've looked online for a resource that would help edit the below to work on a 64 bit system. My mind isn't grasping what is probably very obvious ...

    Can someone suggest a good resource I could easily understand or provide direct assistance here ?

    Thank you.




    Please Login or Register  to view this content.
    In 32 bit the macro copies a UserForm showing on screen then pastes that image to the worksheet. It does not take a complete screen image.
    Last edited by Logit; 03-03-2019 at 11:59 AM.

  2. #2
    Valued Forum Contributor Haluk's Avatar
    Join Date
    02-14-2019
    Location
    Turkiye
    MS-Off Ver
    2010 - 64 Bit on Windows-11 (22 H2) 64 Bit
    Posts
    1,150

    Re: Change User 32 to User 64

    I use the URL below when I use API functions ... Most of the functions are given.

    https://www.jkp-ads.com/articles/apideclarations.asp

    In your case, (not tested) for 64 bit you have to use this;

    Please Login or Register  to view this content.
    And, the below Microsoft-link gives a general information about the subject;

    https://docs.microsoft.com/en-us/off...tions-overview
    Last edited by Haluk; 03-03-2019 at 12:51 PM.

  3. #3
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    7,014

    Re: Change User 32 to User 64

    .
    Thank you for your assistance. Works great !

    I looked over the two sites for an indication if it could be written to accommodate both 32 bit and 64 bit.

    Perhaps something like :


    Please Login or Register  to view this content.

    Is this possible ?

  4. #4
    Valued Forum Contributor Haluk's Avatar
    Join Date
    02-14-2019
    Location
    Turkiye
    MS-Off Ver
    2010 - 64 Bit on Windows-11 (22 H2) 64 Bit
    Posts
    1,150

    Re: Change User 32 to User 64

    It should be something like;

    Please Login or Register  to view this content.
    Last edited by Haluk; 03-03-2019 at 01:02 PM.

  5. #5
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    7,014

    Re: Change User 32 to User 64

    .
    Ok ... thanks.

    I had tried it with the 64 bit first then the VBA7 next. Didn't think to switch it around.

    Great !

    Kudos and cheers !!

+ 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. Change event to Convert (calculate) user input if user types % sign
    By soundneedle in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-18-2016, 12:01 PM
  2. Replies: 1
    Last Post: 05-27-2015, 01:31 PM
  3. change event macro to evaluate windows user who initiated the change then send email
    By pmanoloff in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-23-2012, 03:31 PM
  4. Replies: 15
    Last Post: 04-17-2012, 08:19 AM
  5. Insert user's name into cell based on windows user login when a button is clicked.
    By jonvanwyk in forum Excel Programming / VBA / Macros
    Replies: 19
    Last Post: 08-16-2011, 01:08 PM
  6. Pause macro for user input then search for user's answer across multiple sheets
    By sassy2 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 11-04-2009, 03:55 AM
  7. How to change the desktop name from being user specific to general user?
    By punter in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-25-2007, 04:06 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