Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
The code with API functions below is working perfectly almost on all
computers but on a few ones is not working. It's from the code to get a full user name. What could be the cause of this? Thanks ...... Private Declare Function apiNetGetDCName _ Lib "netapi32.dll" Alias "NetGetDCName" _ (ByVal servername As Long, _ ByVal DomainName As Long, _ bufptr As Long) As Long ' function frees the memory that the NetApiBufferAllocate ' function allocates. Private Declare Function apiNetAPIBufferFree _ Lib "netapi32.dll" Alias "NetApiBufferFree" _ (ByVal buffer As Long) _ As Long ' Retrieves the length of the specified wide string. Private Declare Function apilstrlenW _ Lib "kernel32" Alias "lstrlenW" _ (ByVal lpString As Long) _ As Long Private Declare Function apiNetUserGetInfo _ Lib "netapi32.dll" Alias "NetUserGetInfo" _ (servername As Any, _ UserName As Any, _ ByVal level As Long, _ bufptr As Long) As Long ' moves memory either forward or backward, aligned or unaligned, ' in 4-byte blocks, followed by any remaining bytes Private Declare Sub sapiCopyMem _ Lib "kernel32" Alias "RtlMoveMemory" _ (Destination As Any, _ Source As Any, _ ByVal Length As Long) Private Declare Function apiGetUserName Lib _ "advapi32.dll" Alias "GetUserNameA" _ (ByVal lpBuffer As String, _ nSize As Long) _ As Long Private Const MAXCOMMENTSZ = 256 Private Const NERR_SUCCESS = 0 Private Const ERROR_MORE_DATA = 234& Private Const MAX_CHUNK = 25 Private Const ERROR_SUCCESS = 0& ..... |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Multiple functions, conditional functions | Excel Worksheet Functions | |||
How to convert cell formula functions to code functions | Excel Discussion (Misc queries) | |||
efficiency: database functions vs. math functions vs. array formula | Excel Discussion (Misc queries) | |||
Looking for a site with functions that substitute the ATP functions | Excel Worksheet Functions | |||
excel functions and User defined functions | Excel Programming |