+ Reply to Thread
Results 1 to 8 of 8

32bit 64bit PCname username

  1. #1
    Registered User
    Join Date
    05-07-2013
    Location
    Amsterdam
    MS-Off Ver
    Excel 2013
    Posts
    72

    32bit 64bit PCname username

    Hi,

    in our company we have multiple version of PC's 32-64bit in combination of office 32 -64bit. We have all, some are not updated or some countries are just behind everything and living under a rock.
    At moment i dont have any testers, i no idea who has what.

    I want pcname and userID (not username), but it needs run for all combinations.

    As i dont have testers, is this the way to go?
    Please Login or Register  to view this content.

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

    Re: 32bit 64bit PCname username

    That's not conditional compilation. You need:

    Please Login or Register  to view this content.
    Remember what the dormouse said
    Feed your head

  3. #3
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    365 Win 11
    Posts
    7,238

    Re: 32bit 64bit PCname username

    Wouldn't:
    Please Login or Register  to view this content.
    Suffice?

  4. #4
    Registered User
    Join Date
    05-07-2013
    Location
    Amsterdam
    MS-Off Ver
    Excel 2013
    Posts
    72

    Re: 32bit 64bit PCname username

    Thanks that works!!

    Although i am getting a compile on the Username, dont know why that is

  5. #5
    Registered User
    Join Date
    05-07-2013
    Location
    Amsterdam
    MS-Off Ver
    Excel 2013
    Posts
    72

    Re: 32bit 64bit PCname username

    Quote Originally Posted by Kyle123 View Post
    Wouldn't:
    Please Login or Register  to view this content.
    Suffice?
    that is the username, i need the UserID / the Windows Authentification.

  6. #6
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    365 Win 11
    Posts
    7,238

    Re: 32bit 64bit PCname username

    Have you tried it?

  7. #7
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    365 Win 11
    Posts
    7,238

    Re: 32bit 64bit PCname username

    I reckon that:
    Environ("computername")

    Would do you too and you can dispense with the APIs

  8. #8
    Registered User
    Join Date
    05-07-2013
    Location
    Amsterdam
    MS-Off Ver
    Excel 2013
    Posts
    72

    Re: 32bit 64bit PCname username

    Quote Originally Posted by Kyle123 View Post
    Have you tried it?
    Damn.. me bad.. been looking at the wrong macro assign, basically running the wrong button
    Been using this..
    Please Login or Register  to view this content.
    But u are right, i did try this, but if you press on the same button constantly than its time for an espresso.
    Please Login or Register  to view this content.
    Thanks!

+ 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] VBA hide Userform X - compatible for 32bit & 64bit
    By sintek in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-23-2019, 11:37 AM
  2. [SOLVED] update 32bit vba to 64bit
    By nigelog in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-31-2017, 08:46 AM
  3. [SOLVED] update 32bit vba to 64bit
    By nigelog in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-31-2017, 10:19 AM
  4. Convert 32Bit to 64Bit
    By YasserKhalil in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 01-10-2015, 07:42 PM
  5. 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
  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